Help to Index unique records in Multiple columns

[darrenmccoy]

Hi Experts, Could you help me with formulas to index data where there are duplicates in multiple columns?
I am trying to find counts of all unique records and tabulate it.
Here is a sample of the data to be indexed. The found records are UID from a CRM.

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 110px"><col width="122"><col width="100"></colgroup><tbody>[TR]
[TD="bgcolor: #FFF2CC"]NAME[/TD]
[TD="bgcolor: #FFF2CC"]PHONE[/TD]
[TD="bgcolor: #FFF2CC"]EMAIL[/TD]
[/TR]
[TR]
[TD="bgcolor: #FFF2CC"]NOT FOUND[/TD]
[TD="bgcolor: #FFF2CC"]0036F00003EAyMl[/TD]
[TD="bgcolor: #FFF2CC"]0036F00003EAyMl[/TD]
[/TR]
[TR]
[TD="bgcolor: #FFF2CC"]NOT FOUND[/TD]
[TD="bgcolor: #FFF2CC"]NOT FOUND[/TD]
[TD="bgcolor: #FFF2CC"]0036F00003KKCCU[/TD]
[/TR]
[TR]
[TD="bgcolor: #FFF2CC"]NOT FOUND[/TD]
[TD="bgcolor: #FFF2CC"]NOT FOUND[/TD]
[TD="bgcolor: #FFF2CC"]0036F00003KKCCU[/TD]
[/TR]
[TR]
[TD="bgcolor: #FFF2CC"]NOT FOUND[/TD]
[TD="bgcolor: #FFF2CC"]NOT FOUND[/TD]
[TD="bgcolor: #FFF2CC"]NOT FOUND[/TD]
[/TR]
[TR]
[TD="bgcolor: #FFF2CC"]NOT FOUND[/TD]
[TD="bgcolor: #FFF2CC"]0036F00002wW3QR[/TD]
[TD="bgcolor: #FFF2CC"]0036F00002wW3QR[/TD]
[/TR]
[TR]
[TD="bgcolor: #FFF2CC"]0036F000036skXP[/TD]
[TD="bgcolor: #FFF2CC"]NOT FOUND[/TD]
[TD="bgcolor: #FFF2CC"]NOT FOUND[/TD]
[/TR]
[TR]
[TD="bgcolor: #FFF2CC"]0036F00002FauAq[/TD]
[TD="bgcolor: #FFF2CC"]0036F00002FauAq[/TD]
[TD="bgcolor: #FFF2CC"]0036F00002FauAq[/TD]
[/TR]
[TR]
[TD="bgcolor: #FFF2CC"]0036F00002FauAq[/TD]
[TD="bgcolor: #FFF2CC"]0036F00002FauAq[/TD]
[TD="bgcolor: #FFF2CC"]0036F00002FauAq[/TD]
[/TR]
[TR]
[TD="bgcolor: #FFF2CC"]0036F00003GdlKu[/TD]
[TD="bgcolor: #FFF2CC"]0036F00003Gcm5Z[/TD]
[TD="bgcolor: #FFF2CC"]0036F00003Gcm5Z[/TD]
[/TR]
[TR]
[TD="bgcolor: #FFF2CC"]0036F00003GdlKu[/TD]
[TD="bgcolor: #FFF2CC"]0036F00003Gcm5Z[/TD]
[TD="bgcolor: #FFF2CC"]0036F00003Gcm5Z[/TD]
[/TR]
[TR]
[TD="bgcolor: #FFF2CC"]0036F00003GdlKu[/TD]
[TD="bgcolor: #FFF2CC"]0036F00003Gcm5Z[/TD]
[TD="bgcolor: #FFF2CC"]0036F00003Gcm5Z[/TD]
[/TR]
[TR]
[TD="bgcolor: #FFF2CC"]NOT FOUND[/TD]
[TD="bgcolor: #FFF2CC"]NOT FOUND[/TD]
[TD="bgcolor: #FFF2CC"]NOT FOUND[/TD]
[/TR]
[TR]
[TD="bgcolor: #FFF2CC"]NOT FOUND[/TD]
[TD="bgcolor: #FFF2CC"]0036F00003AJI3r[/TD]
[TD="bgcolor: #FFF2CC"]0036F00003AJI3r[/TD]
[/TR]
[TR]
[TD="bgcolor: #FFF2CC"]NOT FOUND[/TD]
[TD="bgcolor: #FFF2CC"]0036F00003AJI3r[/TD]
[TD="bgcolor: #FFF2CC"]0036F00003AJI3r[/TD]
[/TR]
[TR]
[TD="bgcolor: #FFF2CC"]NOT FOUND[/TD]
[TD="bgcolor: #FFF2CC"]0036F00003AJI3r[/TD]
[TD="bgcolor: #FFF2CC"]0036F00003AJI3r[/TD]
[/TR]
[TR]
[TD="bgcolor: #FFF2CC"]NOT FOUND[/TD]
[TD="bgcolor: #FFF2CC"]0036F00001vygDz[/TD]
[TD="bgcolor: #FFF2CC"]0036F00001vygDz[/TD]
[/TR]
[TR]
[TD="bgcolor: #FFF2CC"]NOT FOUND[/TD]
[TD="bgcolor: #FFF2CC"]0036F00001vygDz[/TD]
[TD="bgcolor: #FFF2CC"]0036F00001vygDz[/TD]
[/TR]
[TR]
[TD="bgcolor: #FFF2CC"]NOT FOUND[/TD]
[TD="bgcolor: #FFF2CC"]NOT FOUND[/TD]
[TD="bgcolor: #FFF2CC"]0036F000034F4Fm[/TD]
[/TR]
[TR]
[TD="bgcolor: #FFF2CC"]NOT FOUND[/TD]
[TD="bgcolor: #FFF2CC"]NOT FOUND[/TD]
[TD="bgcolor: #FFF2CC"]0036F000034F4Fm[/TD]
[/TR]
[TR]
[TD="bgcolor: #FFF2CC"]NOT FOUND[/TD]
[TD="bgcolor: #FFF2CC"]NOT FOUND[/TD]
[TD="bgcolor: #FFF2CC"]0036F000034F4Fm[/TD]
[/TR]
[TR]
[TD="bgcolor: #FFF2CC"]NOT FOUND[/TD]
[TD="bgcolor: #FFF2CC"]NOT FOUND[/TD]
[TD="bgcolor: #FFF2CC"]0036F00003KKCCU[/TD]
[/TR]
[TR]
[TD="bgcolor: #FFF2CC"]NOT FOUND[/TD]
[TD="bgcolor: #FFF2CC"]NOT FOUND[/TD]
[TD="bgcolor: #FFF2CC"]0036F00003KKCCU[/TD]
[/TR]
</tbody>[/TABLE]

I should have an output that has the unique UID records and a total count.

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 161px"><col width="100"></colgroup><tbody>[TR]
[TD="bgcolor: #D9D9D9"]Unique Record[/TD]
[TD="bgcolor: #666666"]COUNTA[/TD]
[/TR]
[TR]
[TD="bgcolor: #F3F3F3"]0036F00001pBJXO[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: #F3F3F3"]0036F00001pi66U[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: #F3F3F3"]0036F00001qh895[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: #F3F3F3"]0036F00001rCzpf[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="bgcolor: #F3F3F3"]0036F00001rZmIN[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="bgcolor: #F3F3F3"]0036F00001rZmY4[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="bgcolor: #F3F3F3"]0036F00001skFEx[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: #F3F3F3"]0036F00001skOB5[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="bgcolor: #F3F3F3"]0036F00001tDV25[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: #F3F3F3"]0036F00001tfjcl[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: #F3F3F3"]0036F00001uhvkY[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="bgcolor: #F3F3F3"]0036F00001uhzz8[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="bgcolor: #F3F3F3"]0036F00001uiz9f[/TD]
[TD="align: right"]3[/TD]
[/TR]
</tbody>[/TABLE]

Thank you for being helpful!

 

[sandy666]

This is Excel forum not Google Sheet

have a nice day

 

[Peter_SSs]

Thank you. FYI, I did get this to work using spreadsheet formulas in Ecel.

You're welcome.