selecting cells without certain value

[OTS]

hi. i have 2 columns, 1 with names and the other with some numbers. for
example apples:2, bananas:4, carrots:6, dingos:8. now i want to choose
the name which has the minimum number, in this case apples. i want to
make a sentence such that it comes out something like "there are 2 more
bananas than apples, 4 more carrots than apples, 6 more dingos than
apples". i know how to get the name for the minimum number, the problem
i have is how to use everything but that name.

thanks for any help.

 

[Pete_UK]

It's a bit too late for me to come up with the complete formula for
that, but you could look up the SMALL function in Excel Help - this
will allow you to find the smallest value (equivalent to MIN, the
second smallest, the third smallest etc. A similar function, LARGE,
allows you to find the nth largest value.

Hope this helps.

Pete

 

[OTS]

yes, the small and large functions work for me. thanks!

 

[Pete_UK]

Glad to be of some help.

Pete