selecting cells without certain value
 

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.

selecting cells without certain value
 

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 wrote:
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.

selecting cells without certain value
 

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

selecting cells without certain value
 

Glad to be of some help.

Pete

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