I've created a pivot table of about 2000 rows of data to try and locate duplicate information on particular columns. I thought that pivot tables automatically show totals in descending order from most times repeated to 1. However, I'm having to search the entire pivot table for items that show more than 1.
For example, the table currently reads:
Phone number------Total
777-777-7777-------1
999-999-9999-------2
222-222-2222-------1
444-444-4444-------1
333-333-3333-------2
I need it to list in descending order:
Phone number------Total
999-999-9999-------2
333-333-3333-------2
222-222-2222-------1
777-777-7777-------1
444-444-4444-------1
I hope this makes sense. If so, can someone please help me out here? Thanks a mil!!!
For example, the table currently reads:
Phone number------Total
777-777-7777-------1
999-999-9999-------2
222-222-2222-------1
444-444-4444-------1
333-333-3333-------2
I need it to list in descending order:
Phone number------Total
999-999-9999-------2
333-333-3333-------2
222-222-2222-------1
777-777-7777-------1
444-444-4444-------1
I hope this makes sense. If so, can someone please help me out here? Thanks a mil!!!