|
Condtional Quartile statement
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 |
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 |
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" wrote in message ... 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 |
Thanks for the feedback
-- Regards, Peo Sjoblom (No private emails please) "BillReese" wrote in message news:BXZ1f.20945$HM1.3170@trnddc04... 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" wrote in message ... 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 |
| All times are GMT +1. The time now is 02:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com