| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate MEDIAN of Last x Rows in a Column
Hi daddylonglegs,
Perfect! Thank you very much for your time and assistance. Cheers, Sam daddylonglegs wrote: For the first column of data =MEDIAN(OFFSET(INDEX(INDEX(data,0,1),COUNT(INDEX( data,0,1))),,,MAX(-COUNT(INDEX(data,0,1)),-5),)) This gives the median of the last 5 numbers in the column, assuming the rules you outlined are obeyed. If there are less than 5 values it gives the median of whatever numbers there are. For column 2 change all 1s to 2s or you could use some sort of COLUMN reference to apply one formula which can be copied across -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200611/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I combine spreadsheets and documents in one file? | Excel Discussion (Misc queries) | |||
| Copy rows of one sheet into mutiple sheets based on column value | Excel Discussion (Misc queries) | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Threaded Mode
