I have a raw data that contains the following structure
There are essentially two things I want to do in a formula: 1) Extract rows that contains Route=2 (cell G1), Direction=North (cell G2, Segment=14_15 (cell G3) 2) Get the 0.5 percentile of the values in those extracted rows.
Based on that logic I have written:
=PERCENTILE.INC(IF(AND(CT_Query!$A:$A=G1, CT_Query!$B:$B=G2, $C:$C=G3), $E:$E), 0.5)
After I pressed CSE, I got value 0.
Can anyone help tell me what went wrong?
Thanks a lot in advance for your help!
Aucun commentaire:
Enregistrer un commentaire