I have an Excel sheet where I want to look up a value and then calculate a percentile across multiple columns. I get how to calculate a percentile across multiple columns and how to calculate a percentile based on meeting a certain criteria - but I have no idea how to combine the two.
This is difficult to explain typed out - see the attached. I understand how to calculate G2 and G3, but G4 (which is kind of a combination of the two) is where I am stumped. This is a simplified version, the real one has significantly more data.
Thanks in advance.