Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
selecting cells without certain value
yes, the small and large functions work for me. thanks!
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
selecting cells without certain value
Glad to be of some help.
Pete OTS wrote: yes, the small and large functions work for me. thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting the correct number from a range of cells | Excel Worksheet Functions | |||
Selecting data from different cells for a chart | Charts and Charting in Excel | |||
selecting cells | Excel Discussion (Misc queries) | |||
selecting cells | Excel Discussion (Misc queries) | |||
Hightlighting crosshairs when selecting cells | Excel Discussion (Misc queries) |