Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
IF Statement | New Users to Excel | |||
How to calculate a sum as one outcome of an IF statement | Excel Worksheet Functions | |||
Quartile Function | Excel Discussion (Misc queries) |