| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| filtering entries in an excel costs schedule? | Excel Worksheet Functions | |||
| advanced filtering based on entries ABOVE those I wish to keep | Excel Discussion (Misc queries) | |||
| count the number of cell entries after filtering | Excel Discussion (Misc queries) | |||
| How can I extend the filtering limits of 1000 unique entries | Excel Discussion (Misc queries) | |||
| Filtering a column to exclude any repeated entries. | Excel Discussion (Misc queries) | |||
Linear Mode
