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
<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>
Tech Name | Date Under Rpt | ||
ALLEN, ROBERT | 8/2/2019 | ||
BANKS, WILLIAM | 8/1/2019 | ||
CLARKE, JOHN G | 8/2/2019 | ||
COLE, KENDRICK | 8/2/2019 | ||
FARMER, LLOYD M | 8/2/2019 | ||
HAMBRICK, TERRANCE A | 8/2/2019 | ||
HANNAH, JOHN G | 8/2/2019 | ||
JENSEN, DONALD R | 8/2/2019 | ||
JORDAN, HAROLD | 8/2/2019 | ||
KNIGHT, BRUCE | 8/2/2019 | ||
KOLDEN, RONALD | 8/2/2019 | ||
REESE, EDWIN S | 8/2/2019 | ||
SCOTT, CALVIN F | 8/2/2019 | ||
SMITH, TERRANCE | 8/2/2019 | ||
SWINFORD, TRAVIS W | 8/2/2019 | ||
ALLEN, ROBERT | 8/2/2019 | ||
BANKS, WILLIAM | 8/1/2019 | ||
BANKS, WILLIAM | 8/1/2019 | ||
BANKS, WILLIAM | 8/2/2019 | ||
BANKS, WILLIAM | 8/2/2019 | ||
BISHOP, CHAD B | 8/2/2019 | ||
BISHOP, CHAD B | 8/1/2019 | ||
BISHOP, CHAD B | 8/2/2019 | ||
CHEEKS, DAVID | 8/2/2019 | ||
CLOWER, BARRY | 8/2/2019 | ||
CLOWER, BARRY | 8/1/2019 | ||
CLOWER, BARRY | 8/1/2019 | ||
CLOWER, BARRY | 8/2/2019 | ||
COLE, KENDRICK | 8/2/2019 | ||
DAILEY, CHRIS D | 8/2/2019 | ||
FORBES, GAVIN A | 8/2/2019 | ||
GREEN, CARL E | 8/1/2019 | ||
GREEN, CARL E | 8/2/2019 |