![]() |
|
|
|
#1
|
|||
|
|||
|
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 |