filtering for repetitive entries
 

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?

filtering for repetitive entries
 

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?