| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ranking with duplication and gaps
I have a column of number that are in an irregular sequence (e.g., 1, 1, 3,
6, 1, 7, 7, 7, 9). I need a formula that will determine the highest value in the column that is less than the value in a given cell in that column. For example, if I select a cell with the number 6 in it, I need to know what is the highest number less than 6. I have tried RANK and LARGE, but I can't figure out how to make them work. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplication | Excel Discussion (Misc queries) | |||
| Transpose Column With Gaps to Column With no gaps | Excel Discussion (Misc queries) | |||
| Duplication | Excel Discussion (Misc queries) | |||
| RANK, duplicate ranking but no gaps in rank | Excel Worksheet Functions | |||
| Transpose Column With Gaps to Row With No Gaps? | Excel Discussion (Misc queries) | |||
Threaded Mode
