camper12
asked on
Excel function percentile rank based on selected label
Hi,
Is there a way to calculate percentile rank using a conditional statement. For example, PERCENTRANK.EXC of column Ratio if Rating value is AAA. Example is attached.
Thanks
EE-example.xlsx
Is there a way to calculate percentile rank using a conditional statement. For example, PERCENTRANK.EXC of column Ratio if Rating value is AAA. Example is attached.
Thanks
EE-example.xlsx
Given the values on that sheet, what should the results be?
Try this formula in C2:
=PERCENTRANK.EXC(IF($A$2:$ B$24=A2,$B $2:$B$24), B2,1)
This is an array formula so use Ctrl+Shift+Enter and then copy down. See if this gives you the results you are looking for.
Flyster
=PERCENTRANK.EXC(IF($A$2:$
This is an array formula so use Ctrl+Shift+Enter and then copy down. See if this gives you the results you are looking for.
Flyster
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.