Hello. I have two columns
A - dates in the form: day/month/year
B- a dollar amount spent that day.
What is the best way to provide at the end a filter which can display to me the totals per month? and for the whole year?
Thanks
Hello. I have two columns
A - dates in the form: day/month/year
B- a dollar amount spent that day.
What is the best way to provide at the end a filter which can display to me the totals per month? and for the whole year?
Thanks
Use a Pivot Table and group the dates according to month.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks