Jeff Gentry
New Member
- Joined
- Oct 6, 2005
- Messages
- 43
I am using the advanced filter function to filter data and then subtotaling the filtered data. Before subtotaling the filtered data I am sorting by account code. 5200-100-538-2002 is an example of an account code. When I try to subtotal the data I am getting 4 different subtotals for each account code rather than 1. If I do alt ; after applying the advanced filter and copy the visible cells to a different worksheet I do not have any problems with subtotals. However, this is time consuming when working with multiple pages of data. My goal is to be able to subtotal data after applying the advanced filter without any problems. I would appreciate any help you may provide on this?