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

Within parentheses, separate with comma the contiguous parts.

HTH
Kostis Vezerides

On Oct 11, 5:32 pm, Michael Gudyka
wrote:
How can I use the percentrank function on non-contiguous cells? Thanks in
advance as always.
--
Michael Gudyka
St. Charles, IL