ExcelBanter - Percentrank Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Percentrank Function (https://www.excelbanter.com/excel-worksheet-functions/161781-percentrank-function.html)

Michael Gudyka

Percentrank Function

How can I use the percentrank function on non-contiguous cells? Thanks in
advance as always.
--
Michael Gudyka
St. Charles, IL

vezerid

Percentrank Function

=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

All times are GMT +1. The time now is 03:30 PM.