Hi,
you have option to group the file...Bring the data in excel pivit..and right
clickselect group...and select group by year..
you can also group my month Quarter too..
Regards
Chethan Kumar BN
On Tue, Oct 4, 2011 at 1:32 AM, John A. Smith johnasmit...@gmail.comwrote:
Attached is
Chethan,
Thank you for your quick and enlightening response. This opens up new
avenues for me. Thank you very much!!!
John
On Mon, Oct 3, 2011 at 4:26 PM, B.N.Chethan kumar chetankumar1...@gmail.com
wrote:
Hi,
you have option to group the file...Bring the data in excel pivit..and
Dear John,
You can also try...
Pivot Table Tools-Options-Group Selection...
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Tue, Oct 4, 2011 at