Thank you, I tried to do the same exact thing, but I was trying to put the
"IF" on the outside of the quartile..

now it works very, very good.

Tom


"Peo Sjoblom" <terre08@mvps.org> wrote in message
news:ePFLgPGzFHA.2348@TK2MSFTNGP15.phx.gbl...
> 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" <BillReese@Unicom.com> 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
>>
>