Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell reference math
I have a spreadsheet that is filled by experimental data. The number of data
points (rows) can be 300-6000. I am tasked to take 50 point averages at the 25% and 75% points of the data. I can get the number of data points using using the COUNTIF function. I need to be able to adjust the AVERAGE function based on the COUNTIF results. Is there a way to set the cell reference based upon this result? Are there any other ideas as to how to solve this? If my problem is not clear, please ask questions. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell reference math
JR,
How about these, for data in column A, and a title value in cell A1 =AVERAGE(OFFSET(A1,COUNT(A:A)*0.25-25,0,50,1)) and =AVERAGE(OFFSET(A1,COUNT(A:A)*0.75-25,0,50,1)) HTH, Bernie MS Excel MVP "JR" wrote in message ... I have a spreadsheet that is filled by experimental data. The number of data points (rows) can be 300-6000. I am tasked to take 50 point averages at the 25% and 75% points of the data. I can get the number of data points using using the COUNTIF function. I need to be able to adjust the AVERAGE function based on the COUNTIF results. Is there a way to set the cell reference based upon this result? Are there any other ideas as to how to solve this? If my problem is not clear, please ask questions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to include a cell reference that is contained in a cell withi. | Excel Worksheet Functions | |||
How do I leave formula cell blank if 2nd reference cell is empty? | Excel Discussion (Misc queries) | |||
copied formula has correct cell reference, but result of original | Excel Worksheet Functions | |||
Problem with formulas changing cell reference | Excel Discussion (Misc queries) | |||
Flexible Cell Reference | Excel Discussion (Misc queries) |