| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ranking with some blank spaces
I am creating a ranking sheet with 20 rows. There will be a differing amount
of numbers to rank. Sometimes there may only be 10 numbers to rank and sometimes more or less. How do you prevent the blank spaces from being part of your ranking? In other words, if I have 10 numbers, I want to rank 1 through 10 and ignore the spaces 11 through 20. -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill blank cells with spaces | Excel Worksheet Functions | |||
| Blank Spaces on Sort | Excel Discussion (Misc queries) | |||
| Blank spaces | Excel Discussion (Misc queries) | |||
| CELL IS BLANK BUT NEED IT FILLED WITH SPACES TO A SPECIFIC LENGTH | Excel Worksheet Functions | |||
| "False" filling in the blank spaces | Excel Discussion (Misc queries) | |||
Threaded Mode
