I have a list of store locations in column A, total sales in column B, sales percentile ranking column C.
Assume 20 rows (locations) for the example
I would like to return the min, max, and average sales amounts where percentile rank is between two values.
Can anyone help? I am not used to Excel syntax and my brain went melty.