Pivot Table

MaineLady · #1 07-28-2019, 03:26 AM

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.

Alansidman · #2 07-28-2019, 06:50 AM

Can you upload a sample data base that can be acted upon.

Lugh · #3 08-03-2019, 04:49 PM

Try sorting the DB by Address, then use the SubTotal function with Count.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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