Scenario:
Column A Column B Column C. Column D (Percentile Min) Percentile 10% Percentile 20%
Aetna Dr. 1 54% Aetna 0.0 .10 .20
Aetna Dr. 2 53% Aetna
Aetna Dr. 3 60% Aetna
Aetna Dr. 4 82% Aetna
L8 M8 N8
Aetna Cigna UHC
=Percentile.Inc(Index($C:$C, Match($L8, $D:$D, 0)), .2)
Problem is this formula only returns the first value available in the index. So for example this formula yields 54% for the percentile min of 0 when it should be 53%. Thoughts?
Bookmarks