| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
median calculation
I have a column that has entries that start with Fiscal year 07 numbers which
are from 07/01/07 to 06/30/08, and a cell that gives me the average so far this year. Is there a way to take this col Fiscal year and get a median for FY07-08? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
median calculation
say your data is in A1 thru A366:
=MEDIAN(A1:A366) should be good, because MEDIAN will ignore the blanks associated with data not yet available. -- Gary''s Student - gsnu200756 "Pammy" wrote: I have a column that has entries that start with Fiscal year 07 numbers which are from 07/01/07 to 06/30/08, and a cell that gives me the average so far this year. Is there a way to take this col Fiscal year and get a median for FY07-08? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
median calculation
Use the MEDIAN function, as in:
=MEDIAN(A1:A6) On Nov 16, 1:25 pm, Pammy wrote: I have a column that has entries that start with Fiscal year 07 numbers which are from 07/01/07 to 06/30/08, and a cell that gives me the average so far this year. Is there a way to take this col Fiscal year and get a median for FY07-08? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Median calculation of grouped data. | Excel Worksheet Functions | |||
| Median | Excel Discussion (Misc queries) | |||
| Max/Min/Median | Excel Worksheet Functions | |||
| Median calculation and ignore zeros | Excel Discussion (Misc queries) | |||
| Median function | Excel Discussion (Misc queries) | |||
Linear Mode
