filtering for repetitive entries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a very large database of monthly meter readings. Some months have
multiple readings, which throws me off for using pivot table. Is there a way
to filter the table in a way that adds the values for repetitive months?
 
Try using the SubTotals feature on the Data menu.
Your data will have to be sorted so that identical months are in adjacent rows.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"TimmyD"
wrote in message
I have a very large database of monthly meter readings. Some months have
multiple readings, which throws me off for using pivot table. Is there a way
to filter the table in a way that adds the values for repetitive months?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pivot table rolling 12 month filter? 1
2003 Pivot Table Filter (items dropped in the Page Fields) 1
Pivot Table Duplicate January 2
Sort pivot table field (droplist) by month or original data 1
Duplicate Entries 1
Data-Validation -List - Pick from a drop down menu 4
Averaging values 1
Show current Report Filtered in Pivot Chart 5

Back
Top