Percentrank Function

M

Michael Gudyka

How can I use the percentrank function on non-contiguous cells? Thanks in
advance as always.
 
V

vezerid

=PERCENTRANK((A1:A5,B6:B10,D23:D40),F1)

Within parentheses, separate with comma the contiguous parts.

HTH
Kostis Vezerides
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with Formula 2
Excel PERCENTRANK help 3
Are PercentRank and Rankperc the same function? 1
Median Formula not working properly 2
what is the underlying formula for the percentrank function 1
Percentrank 1
How To Percentrank by Specific Range 1
Need Help with Percentrank formula 4

Top