Percentrank Limitation?

[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

 

[Harlan Grove]

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?

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).

 

[Keith Budzynski]

You were correct. I had one row with #N/A in it.

Thanks,
Keith