Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need to help with Excel (beginner) -- year row and month column
Hello all,
I would like to know how to do the following ( I am newbie to Excel :) ) I have this 2004-11-30 10 2004-12-31 7 2005-01-31 5 2005-02-28 20 2005-03-31 19 2005-04-30 17 2005-05-31 16 2005-06-30 15 2005-07-31 18 2005-08-31 8 2005-09-30 9 2005-10-31 8 2005-11-30 9 2005-12-31 4 2006-01-31 15 2006-02-28 23 2006-03-31 15 2006-04-30 6 2006-05-31 2 2006-06-30 1 2006-07-31 3 2006-08-31 3 2006-09-30 2 2006-10-31 2 2006-11-30 5 2006-12-31 11 2007-01-31 2 2007-02-28 3 2007-03-31 4 2007-04-30 5 2007-05-31 6 2007-06-30 14 2007-07-31 13 2007-08-31 12 2007-09-30 11 2007-10-31 4 2007-11-30 3 2007-12-31 9 2008-01-31 9 2008-02-22 7 and I would like to obtain the folloling Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dev Total 2008 2007 2006 2005 2004 any appreciation will be welcome Thank you in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofilter by month & year when I have a column full of dates ?? | Excel Discussion (Misc queries) | |||
Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)??? | Excel Discussion (Misc queries) | |||
Day from year in 1 column & day & month in another | Excel Worksheet Functions | |||
matching month and year column. | Excel Worksheet Functions | |||
count no. of dates in a column that falls on certain month & year | Excel Worksheet Functions |