#1
|
|||
|
|||
Pivot Table
Pivot Tables used to be easy...
I have a large address database. I want to generate a simple table and COUNT the number of LAST NAMES at an ADDRESS. Can someone give me the steps to get that done? Thank you. |
#2
|
||||
|
||||
Can you upload a sample data base that can be acted upon.
|
#3
|
||||
|
||||
Try sorting the DB by Address, then use the SubTotal function with Count.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Switch slicer report connections between pivot table and table | tyjulianchen | Excel | 0 | 02-28-2017 04:54 AM |
Create PIVOT chart using few rows in pivot table | Santhosh_84 | Excel | 1 | 08-31-2015 06:22 AM |
Offset Table and Pivot Table | ubns | Excel | 1 | 04-17-2015 12:28 AM |
Pivot Table Question- Can the table display in the order the boxes were checked/selected? | blackjack | Excel | 0 | 09-13-2014 08:57 PM |
pivot table | aliasadi_07 | Excel | 1 | 03-11-2012 12:49 AM |