Microsoft
Policy
Questions and answers to issues related to Microsoft: Windows, Applications, Development, Hardware, Server, Internet Protocols, Database, Exchange .
»
Applications
»
Microsoft Office
»
Excel
»
CREATE MTD AND YTD
CREATE MTD AND YTD
I would like the MTD and YTD formula based on the DEPCOMB column and CATEGORY column. See the attached Excel file.
So you will have this each month in a summary like below
:
Depcomb Category Mtd Ytd
Thanks
internet advertising
Solution: CREATE MTD AND YTD
Something like this...You can select the month from the TOP and accordingly you can play arround as per whatever you want to do with it...
HTH...
Saurabh....
testing-experts-1-.xls
(266 KB)
(File Type Details)
Data....
Popular Tags
Tags:
2000
2003
2007
cell
cells
chart
convert
copy
excel
Excel 2003
Excel 2007
Excel VBA
file
formula
macro
Microsoft
Microsoft Excel
Microsoft Excel 2003
Microsoft Excel 2007
ms Excel
Office
pivot
range
sheet
vb
vba
vlookup
workbook
worksheet
Browse All Tags