I am looking to display the percentile of a value based on multiple conditions. Column K is my score, Column E is my organization, and Column H is my metric. For these, I'd like to see the percentile for each score based on each individual organization and metric.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Conditional percent rank
JustynaMK
Well-known Member
- Joined
- Aug 28, 2016
- Messages
- 674
- Office Version
- 365
- 2013
- Platform
- Windows
Hi,
Hopefully this Array formula is a good starting point (enter with Ctrl+Shift+Enter):
=PERCENTRANK(IFERROR($K$2:$K$50*IF($E$2:$E$50=E2,1,"")*IF($H$2:$H$50=H2,1,""),""),K2)
I assumed that your headers are in row 1 and your data set is in rows 2:50. Let me know if that helps.
Hopefully this Array formula is a good starting point (enter with Ctrl+Shift+Enter):
=PERCENTRANK(IFERROR($K$2:$K$50*IF($E$2:$E$50=E2,1,"")*IF($H$2:$H$50=H2,1,""),""),K2)
I assumed that your headers are in row 1 and your data set is in rows 2:50. Let me know if that helps.
Upvote
0
Similar threads
- Question
