darrenmccoy
New Member
- Joined
- Mar 26, 2019
- Messages
- 37
- Office Version
- 2019
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>
<colgroup><col style="width: 110px"><col width="122"><col width="100"></colgroup><tbody>
</tbody>
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>
<colgroup><col style="width: 161px"><col width="100"></colgroup><tbody>
</tbody>
Thank you for being helpful!
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>
NAME | PHONE | |
NOT FOUND | 0036F00003EAyMl | 0036F00003EAyMl |
NOT FOUND | NOT FOUND | 0036F00003KKCCU |
NOT FOUND | NOT FOUND | 0036F00003KKCCU |
NOT FOUND | NOT FOUND | NOT FOUND |
NOT FOUND | 0036F00002wW3QR | 0036F00002wW3QR |
0036F000036skXP | NOT FOUND | NOT FOUND |
0036F00002FauAq | 0036F00002FauAq | 0036F00002FauAq |
0036F00002FauAq | 0036F00002FauAq | 0036F00002FauAq |
0036F00003GdlKu | 0036F00003Gcm5Z | 0036F00003Gcm5Z |
0036F00003GdlKu | 0036F00003Gcm5Z | 0036F00003Gcm5Z |
0036F00003GdlKu | 0036F00003Gcm5Z | 0036F00003Gcm5Z |
NOT FOUND | NOT FOUND | NOT FOUND |
NOT FOUND | 0036F00003AJI3r | 0036F00003AJI3r |
NOT FOUND | 0036F00003AJI3r | 0036F00003AJI3r |
NOT FOUND | 0036F00003AJI3r | 0036F00003AJI3r |
NOT FOUND | 0036F00001vygDz | 0036F00001vygDz |
NOT FOUND | 0036F00001vygDz | 0036F00001vygDz |
NOT FOUND | NOT FOUND | 0036F000034F4Fm |
NOT FOUND | NOT FOUND | 0036F000034F4Fm |
NOT FOUND | NOT FOUND | 0036F000034F4Fm |
NOT FOUND | NOT FOUND | 0036F00003KKCCU |
NOT FOUND | NOT FOUND | 0036F00003KKCCU |
<colgroup><col style="width: 110px"><col width="122"><col width="100"></colgroup><tbody>
</tbody>
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>
Unique Record | COUNTA |
0036F00001pBJXO | 1 |
0036F00001pi66U | 1 |
0036F00001qh895 | 1 |
0036F00001rCzpf | 3 |
0036F00001rZmIN | 4 |
0036F00001rZmY4 | 3 |
0036F00001skFEx | 1 |
0036F00001skOB5 | 3 |
0036F00001tDV25 | 1 |
0036F00001tfjcl | 1 |
0036F00001uhvkY | 3 |
0036F00001uhzz8 | 3 |
0036F00001uiz9f | 3 |
<colgroup><col style="width: 161px"><col width="100"></colgroup><tbody>
</tbody>
Thank you for being helpful!