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
 
Top