Howdy, I'm trying to calculate the 25th, 50th (ie median) and 75th percentile
of costs to maintain infrastructure using a dataset which has various (ie 11)
categories to analyse. I'm using the auto filter option to select each
category.

ie

Group Roads
1 $33,911
1 $27,500
1 $34,834
....
11 $11,782 etc

Any advice regarding an appropriate formula would be greatly appreciated.

Cheers
Pete