How about (longest time - shortest time)/100*25?=(max(e:e)-min(e:e))/100*25

"Rum" wrote:

Here is a scenario:

If:
Column A is list of AUTO MAKERS
Column B is list of DEALERSHIPS
Column C is list of dates when DEALERSHIP OPENED
Column D is list of dates when DEALERSHIP READY TO SELL CARS
Column E is the the difference of Column D and Column C (D-C) (Cycle Time)

There are a thousand rows and multiple column in this data set.

I would like to find out how long does it take the 25th percentile of any
DEALERSHIP to get READY TO SELL CARS.

Please share your thoughts.

Rum