Pivot table Question

bwlytkr

Board Regular
Joined
Jun 8, 2012
Messages
71
I have a spreadsheet with a column of names and column of dates. The column of names have duplicate names for same dates. I need to count how many names were on a certain date but my pivot table only sums the name column. I there a way to count the individual names that appear for each date without duplicating them? I think you are supposed to be able to d this in Power Pivot but, I don't know anything about Power Pivot. Below is a sample of the data. Any help would e greatly appreciated


Tech NameDate Under Rpt
ALLEN, ROBERT8/2/2019
BANKS, WILLIAM8/1/2019
CLARKE, JOHN G8/2/2019
COLE, KENDRICK8/2/2019
FARMER, LLOYD M8/2/2019
HAMBRICK, TERRANCE A8/2/2019
HANNAH, JOHN G8/2/2019
JENSEN, DONALD R8/2/2019
JORDAN, HAROLD8/2/2019
KNIGHT, BRUCE8/2/2019
KOLDEN, RONALD8/2/2019
REESE, EDWIN S8/2/2019
SCOTT, CALVIN F8/2/2019
SMITH, TERRANCE8/2/2019
SWINFORD, TRAVIS W8/2/2019
ALLEN, ROBERT8/2/2019
BANKS, WILLIAM8/1/2019
BANKS, WILLIAM8/1/2019
BANKS, WILLIAM8/2/2019
BANKS, WILLIAM8/2/2019
BISHOP, CHAD B8/2/2019
BISHOP, CHAD B8/1/2019
BISHOP, CHAD B8/2/2019
CHEEKS, DAVID8/2/2019
CLOWER, BARRY8/2/2019
CLOWER, BARRY8/1/2019
CLOWER, BARRY8/1/2019
CLOWER, BARRY8/2/2019
COLE, KENDRICK8/2/2019
DAILEY, CHRIS D8/2/2019
FORBES, GAVIN A8/2/2019
GREEN, CARL E8/1/2019
GREEN, CARL E8/2/2019
<colgroup><col width="159" style="width: 119pt; mso-width-source: userset; mso-width-alt: 5814;"> <col width="64" style="width: 48pt;" span="2"> <col width="102" style="width: 77pt; mso-width-source: userset; mso-width-alt: 3730;"> <tbody> </tbody>
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
4,188
like this?

Date Under RptTech NameCount of Tech Name
08/01/2019
BANKS, WILLIAM
3​
BISHOP, CHAD B
1​
CLOWER, BARRY
2​
GREEN, CARL E
1​
08/02/2019
ALLEN, ROBERT
2​
BANKS, WILLIAM
2​
BISHOP, CHAD B
2​
CHEEKS, DAVID
1​
CLARKE, JOHN G
1​
CLOWER, BARRY
2​
COLE, KENDRICK
2​
DAILEY, CHRIS D
1​
FARMER, LLOYD M
1​
FORBES, GAVIN A
1​
GREEN, CARL E
1​
HAMBRICK, TERRANCE A
1​
HANNAH, JOHN G
1​
JENSEN, DONALD R
1​
JORDAN, HAROLD
1​
KNIGHT, BRUCE
1​
KOLDEN, RONALD
1​
REESE, EDWIN S
1​
SCOTT, CALVIN F
1​
SMITH, TERRANCE
1​
SWINFORD, TRAVIS W
1​
 

bwlytkr

Board Regular
Joined
Jun 8, 2012
Messages
71
like this?

Date Under RptTech NameCount of Tech Name
08/01/2019
BANKS, WILLIAM
3​
BISHOP, CHAD B
1​
CLOWER, BARRY
2​
GREEN, CARL E
1​
08/02/2019
ALLEN, ROBERT
2​
BANKS, WILLIAM
2​
BISHOP, CHAD B
2​
CHEEKS, DAVID
1​
CLARKE, JOHN G
1​
CLOWER, BARRY
2​
COLE, KENDRICK
2​
DAILEY, CHRIS D
1​
FARMER, LLOYD M
1​
FORBES, GAVIN A
1​
GREEN, CARL E
1​
HAMBRICK, TERRANCE A
1​
HANNAH, JOHN G
1​
JENSEN, DONALD R
1​
JORDAN, HAROLD
1​
KNIGHT, BRUCE
1​
KOLDEN, RONALD
1​
REESE, EDWIN S
1​
SCOTT, CALVIN F
1​
SMITH, TERRANCE
1​
SWINFORD, TRAVIS W
1​

<tbody>
</tbody>
I was looking to count the unique values when using the Pivot Table. I was able to figure out how to do this with Power Pivot. Thanks anyway.
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
4,188
You didn't show expected result and you didn't even mention about unique values

have a nice day
 

Forum statistics

Threads
1,085,161
Messages
5,382,071
Members
401,768
Latest member
JAWHARRAH

Some videos you may like

This Week's Hot Topics

Top