Pal,

=INDEX(E:E,SUMPRODUCT((D1:D20000=(LARGE(IF(A1:A200 00="Company
A",D1:D20000),COUNTIF(A1:A20000,"Company A")/2)))*(A1:A20000="Company
A")*ROW(A1:A20000)))

Array entered using Ctrl-Shift-Enter. "Company A" can also be a cell
reference, in case you want to make a table - use advanced filtering to
extract the unique list from your column of company names.

HTH,
Bernie
MS Excel MVP






"PAL" wrote in message
...
I have a spreadsheet with many rows (1000s) and columns. I am trying to
determine how long it took for a percentage of franchises to open. Lets
say
I have:

Column A: Company Name
Column B: Date when product was ready (ie Company A would have the same
date
on each row )
Column C: Franchise Name
Column D: Date franchise opened.
Column E: Col D - Col B

If there were a 1000 rows, 500 of which were for company A. I would like
to
find the amount of time it took for 50% (the first 50 sites for this
example)
of the franchises to open. I am thinking it has to order the dates in
column
D, then find the franchise that was 50th and then take column E as the
answer.

I get that it is an array, but get stuck after that.

Ideas.