How can I use the percentrank function on non-contiguous cells? Thanks in advance as always.
M Michael Gudyka Oct 11, 2007 #1 How can I use the percentrank function on non-contiguous cells? Thanks in advance as always.
V vezerid Oct 11, 2007 #2 =PERCENTRANK((A1:A5,B6:B10,D2340),F1) Within parentheses, separate with comma the contiguous parts. HTH Kostis Vezerides
=PERCENTRANK((A1:A5,B6:B10,D2340),F1) Within parentheses, separate with comma the contiguous parts. HTH Kostis Vezerides