| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
rank text
I'd like to mimic the RANK function with an array of text values.
Can I get a numerical value from each of a list of names? For example: A1 = George Bush A2 = Barack Obama A3 = Abraham Lincoln A4 = James K. Polk TEXTRANK(A1)=3 TEXTRANK(A2)=2 TEXTRANK(A3)=1 TEXTRANK(A4)=4 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| rank the numbers / range of data using 'RANK' and 'ABS' | Excel Worksheet Functions | |||
| rank of text instead of numbers | Excel Discussion (Misc queries) | |||
| RANK, duplicate ranking but no gaps in rank | Excel Worksheet Functions | |||
| Rank where lowest value is highest rank | Excel Worksheet Functions | |||
| Rank items, select one start date, have remaining dates follow based on rank | Excel Discussion (Misc queries) | |||
Threaded Mode
