Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Filter - Calculating Median
Say i want to auto filter a file that has 10 columns of data. I want to
filter by three -five different columns and i want to calculate the median, max, and min of the remaining information only. How would i go about that? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Filter - Calculating Median
Hi John
For the Max and Min there is a built in function - Subtotal. Say your data you want to find the max and Min for is in column H =SUBTOTAL(5,H:H) will give the Min of the visible cells in column H =SUBTOTAL(4,H:H) will give the Max of the visible cells in column H (In both cases, I am assuming the formula is not entered in column H itself. If it is an inserted row above your header in column H, then you would have to make the range H3:Hxxxxx) Average uses 1 as the parameter in Subtotal, but there is no parameter for Median. -- Regards Roger Govier "John Y" <John wrote in message ... Say i want to auto filter a file that has 10 columns of data. I want to filter by three -five different columns and i want to calculate the median, max, and min of the remaining information only. How would i go about that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I auto refresh a column that has an auto filter in place | Excel Discussion (Misc queries) | |||
calculating median and mode | Excel Worksheet Functions | |||
Auto Number the Rows of Auto Filter Result | Excel Discussion (Misc queries) | |||
Calculating Median Value in a large array | Excel Discussion (Misc queries) | |||
Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) |