30000 rows sound like an awful lot for an array formula but here goes

=QUARTILE(IF(A1:A8=23,B1:B8),1)

entered with ctrl + shift & enter



--
Regards,

Peo Sjoblom

(No private emails please)


"Verizon news" wrote in message
news:oBY1f.4040$nz.1267@trnddc03...
Hi,
I have a column with powers in it another column with light levels in it


like:
col A colB
23 742
23 674
22 430
22 231
23 800
20 100


I want to get the first and second Quartile of all the data in the range
for each of the powers. My spreadsheet is large, over 30,000 rows and
the data is not organized well.

How would I extract out quartile "1" of col B to output in Cell C1 I
only want the quartile for data in rows where Col A = 23w?

thank you
BillReese