LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
pol pol is offline
external usenet poster
 
Posts: 129
Default To goup in each month on date column

I am using office 2007 and I have an excel sheet with the following

Date OS

2/1/2009 200.30
2/1/2009 300.00
3/2/2009 400.00
5/2/2009 600.00

How I can group the excel to know outstanding in each month. To group
January os and February os and so on....

Please help

with thanks and Regards

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Summing values in a column if the date in another is of a certain month Harvey Coward New Users to Excel 3 December 4th 07 01:55 PM
If date in column A is less than 15th of month can I display next. Angela Excel Discussion (Misc queries) 4 November 7th 07 02:40 PM
automatic month/date in a column Mitzy Excel Worksheet Functions 4 February 2nd 07 05:13 PM
how do I join month(#) in col a and day(#) in column b to a date? unikpaul Excel Discussion (Misc queries) 1 July 31st 06 09:10 PM
Formula for Extracting Month out of a Date column PokerZan Excel Discussion (Misc queries) 3 June 10th 05 08:30 PM


All times are GMT +1. The time now is 11:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"