Percentrank Limitation?

  • Thread starter Thread starter Keith Budzynski
  • Start date Start date
K

Keith Budzynski

I am trying to use the percentrank function on 1530 rows
of data. I get the #N/A error. The formula works fine
if I only include a couple of hundred rows. Is there a
limitation on the rows? Do I need to sort the rows?

Thanks,
Keith
 
I am trying to use the percentrank function on 1530 rows
of data. I get the #N/A error. The formula works fine
if I only include a couple of hundred rows. Is there a
limitation on the rows? Do I need to sort the rows?
Click to expand...

I'm almost certain the only way you can get PERCENTRANK to return #N/A is to
give it an argument evaluating to #N/A. I'd bet your data range contains at
least one cell evaluating to #N/A. FWIW, I just ran a test of PERCENTRANK with a
range of 2000 simulated 'random' numbers, and it worked without a problem (in
Excel 97 SR-2 - I suppose there's an outside chance this might work differently
in different versions, especially if you haven't installed the latest service
packs).
 
Back
Top