Hi,
I have a list of orders with their turn around time, which belong to
different countries.
I want to calculate the fill rate 90 % for each countries, means that I
want to know in how many days 90% of the orders in France were
delivered, the same for Germany, UK, Italy etc.
I thought I could first calculte the number of records per country with
the SUMPRODUCT formula, but then I don't know how to enter "90% of the
total of the countries' records",
Does someone have any inputs ?
thanks in advance,
Chum
--
chum
------------------------------------------------------------------------
chum's Profile:
http://www.excelforum.com/member.php...o&userid=34262
View this thread:
http://www.excelforum.com/showthread...hreadid=541000