Rank Function returns "#N/A"

  • Thread starter Thread starter ndshep
  • Start date Start date
N

ndshep

Basically, I am using the Rank function on a column of cells with value
that are numbers. However, in order to make the numbers look the wa
that I wanted, I used =TEXT(number,"#,##0").

I'm guessing that RANK does not work on numbers that have had thei
format changed by the TEXT() function. Can anyone suggest a way aroun
this?

THANKS! My first post
 
Back
Top