Notifications
Clear all
Topic starter
Based on the attached excel workbook, I want to return specific "percentile" when following conditions being set.
If Job Level (column B) = X value and Function (column C) = X value and YOE Range (column D) = X value then return percentile.inc (25th, 50th, 66th, 75th and 90th) from set of array in column E and F.
How to do it if the actual data 5 times more than the sample test data and column A in sequence order.
Posted : 24/09/2020 9:10 am
I am not sure if its the most efficent, but the below seems to work
=PERCENTILE.INC(IF(($B$3:$B$712=B3)*($C$3:$C$712=C3)*($D$3:$D$712=D3)*($E$3:$E$712)=0,"",($B$3:$B$712=B3)*($C$3:$C$712=C3)*($D$3:$D$712=D3)*($E$3:$E$712)),0.25)
Posted : 24/09/2020 4:04 pm
