Thread: rank text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
duane duane is offline
external usenet poster
 
Posts: 64
Default 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