This repository was archived by the owner on Oct 26, 2021. It is now read-only.
Conditional Percentile Calculation #5
WayneLambert
announced in
Excel Guides
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
Formula shows the 50th percentile within the [NumericFieldForTable] data range based upon the conditions of the 3 dimensions being met. Notice the formula is an array formula.
{=IF(AND(SelectedValue1="WhateverText1",SelectedValue2="WhateverText2"), PERCENTILE(IF($A1=tblTableName[FieldNameForA1DataRange], IF(tblTableName[FieldName1]="WhateverText1", IF(tblTableName[FieldName2]="WhateverText2",tblTableName[NumericFieldForTable])),50))}Beta Was this translation helpful? Give feedback.
All reactions