| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pick highest number from a list
Hi I have a list of numbers in a1 is like 45 b1 32 c1 47 d1 42 e1 25. I want
to be able to have the cell with the number closest to a1 come up but not going over 45 so d1 42 is the number i want to stand out. Where c1 is closer to 45 but is over 45 so anything over 45 is not counted. Thanks Karl |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop-Down List Choice Affects Multiple Cells? | Excel Worksheet Functions | |||
| Create formula which will number a list in Excel 2003 | Excel Discussion (Misc queries) | |||
| 2 rows, highest No in row 1, then highest number in row 2 relating to that column, possible duplicates | Excel Worksheet Functions | |||
| Lookup in a list of number with a headline | Excel Discussion (Misc queries) | |||
| Finding the 3rd largest number in a list | Excel Worksheet Functions | |||
Threaded Mode
