Find Duplicates with a PivotTable

Thanks 👍👍 much needed for my job .

genius

Hello sir need your help

could you also show how to delete those duplicate values and keep just 1 value in a pivot chart.

verfy useful. Thanks.

thank youuuuuu

thanks a lot!!!!!

i thought count feature counts the number of cells?

Very nice trick,good job Doug!

got it. I speared my data fields instead of putting all there names in a single column. then I went your single column route and it worked like a jem. thanks again

Dude .... you just saved me a nights rest. gracias!!!

Great work. Thanks Doug

Are you abel to remove duplicate records once they are found?