View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
OTS OTS is offline
external usenet poster
 
Posts: 9
Default 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.