Hello,
I have a spreadsheet with 5,000 plus rows and many of the rows containduplicate data. What I am trying to do is if Column A has a duplicate thencompare the data in those rows and if the entire row is a duplicate to somehowidentify them from conditional formating or a formula like COUNTIFS.
Example: A3 and A4 are duplicates so I need to check tosee the remaining part of these two rows are identical.
Is this possible?
<tbody>
[TD="width: 25, bgcolor: transparent"][/TD]
[TD="width: 56, bgcolor: transparent"] A [/TD]
[TD="width: 70, bgcolor: transparent"] B [/TD]
[TD="width: 72, bgcolor: transparent"] C [/TD]
[TD="width: 66, bgcolor: transparent"] D [/TD]
[TD="width: 54, bgcolor: transparent"] E [/TD]
[TD="width: 72, bgcolor: transparent"] H [/TD]
[TD="width: 48, bgcolor: transparent"] I [/TD]
[TD="width: 126, bgcolor: transparent"] J [/TD]
[TD="width: 44, bgcolor: transparent"] K [/TD]
[TD="width: 25, bgcolor: transparent"] 1 [/TD]
[TD="width: 56, bgcolor: transparent"]
[/TD]
[TD="width: 70, bgcolor: transparent"]
[/TD]
[TD="width: 72, bgcolor: transparent"]
[/TD]
[TD="width: 66, bgcolor: transparent"]
[/TD]
[TD="width: 54, bgcolor: transparent"]
[/TD]
[TD="width: 72, bgcolor: transparent"]
[/TD]
[TD="width: 48, bgcolor: transparent"]
[/TD]
[TD="width: 126, bgcolor: transparent"]
[/TD]
[TD="width: 44, bgcolor: transparent"]
[/TD]
[TD="width: 25, bgcolor: transparent"] 2 [/TD]
[TD="width: 56, bgcolor: transparent"] 9351528 [/TD]
[TD="width: 70, bgcolor: transparent"] 9/22/2016 [/TD]
[TD="width: 72, bgcolor: transparent"] 9/22/2016 [/TD]
[TD="width: 66, bgcolor: transparent"] 2016 - Q3 [/TD]
[TD="width: 54, bgcolor: transparent"] Medical [/TD]
[TD="width: 72, bgcolor: transparent"] Outpatient [/TD]
[TD="width: 48, bgcolor: transparent"] I4891 [/TD]
[TD="width: 126, bgcolor: transparent"] Unspec atrial fibrillati [/TD]
[TD="width: 44, bgcolor: transparent"] 93228 [/TD]
[TD="width: 25, bgcolor: transparent"] 3 [/TD]
[TD="width: 56, bgcolor: transparent"] 9351605 [/TD]
[TD="width: 70, bgcolor: transparent"] 10/26/2016 [/TD]
[TD="width: 72, bgcolor: transparent"] 10/26/2016 [/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 54, bgcolor: transparent"] Medical [/TD]
[TD="width: 72, bgcolor: transparent"] Outpatient [/TD]
[TD="width: 48, bgcolor: transparent"] I480 [/TD]
[TD="width: 126, bgcolor: transparent"] Paroxysmal atrial fibril [/TD]
[TD="width: 44, bgcolor: transparent"] 33282 [/TD]
[TD="width: 25, bgcolor: transparent"] 4 [/TD]
[TD="width: 56, bgcolor: transparent"] 9351605 [/TD]
[TD="width: 70, bgcolor: transparent"] 10/26/2016 [/TD]
[TD="width: 72, bgcolor: transparent"] 10/26/2016 [/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 54, bgcolor: transparent"] Medical [/TD]
[TD="width: 72, bgcolor: transparent"] Outpatient [/TD]
[TD="width: 48, bgcolor: transparent"] I480 [/TD]
[TD="width: 126, bgcolor: transparent"] Paroxysmal atrial fibril [/TD]
[TD="width: 44, bgcolor: transparent"] 33282 [/TD]
[TD="width: 25, bgcolor: transparent"] 5 [/TD]
[TD="width: 56, bgcolor: transparent"] 9352003 [/TD]
[TD="width: 70, bgcolor: transparent"] 1/9/2017 [/TD]
[TD="width: 72, bgcolor: transparent"] 1/10/2017 [/TD]
[TD="width: 66, bgcolor: transparent"] 2017 - Q1 [/TD]
[TD="width: 54, bgcolor: transparent"] NULL [/TD]
[TD="width: 72, bgcolor: transparent"] Outpatient [/TD]
[TD="width: 48, bgcolor: transparent"] R008 [/TD]
[TD="width: 126, bgcolor: transparent"] Other abnormalities of h [/TD]
[TD="width: 44, bgcolor: transparent"] 33282 [/TD]
[TD="width: 25, bgcolor: transparent"] 6 [/TD]
[TD="width: 56, bgcolor: transparent"] 9353964 [/TD]
[TD="width: 70, bgcolor: transparent"] 11/7/2016 [/TD]
[TD="width: 72, bgcolor: transparent"] 11/7/2016 [/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 54, bgcolor: transparent"] Medical [/TD]
[TD="width: 72, bgcolor: transparent"] Outpatient [/TD]
[TD="width: 48, bgcolor: transparent"] R002 [/TD]
[TD="width: 126, bgcolor: transparent"] Palpitations [/TD]
[TD="width: 44, bgcolor: transparent"] 93228 [/TD]
[TD="width: 25, bgcolor: transparent"] 7 [/TD]
[TD="width: 56, bgcolor: transparent"] 9353977 [/TD]
[TD="width: 70, bgcolor: transparent"] 11/23/2016 [/TD]
[TD="width: 72, bgcolor: transparent"] 11/23/2016 [/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 54, bgcolor: transparent"] Medical [/TD]
[TD="width: 72, bgcolor: transparent"] Outpatient [/TD]
[TD="width: 48, bgcolor: transparent"] R002 [/TD]
[TD="width: 126, bgcolor: transparent"] Palpitations [/TD]
[TD="width: 44, bgcolor: transparent"] 93228 [/TD]
[TD="width: 25, bgcolor: transparent"] 8 [/TD]
[TD="width: 56, bgcolor: transparent"] 9358036 [/TD]
[TD="width: 70, bgcolor: transparent"] 2/16/2016 [/TD]
[TD="width: 72, bgcolor: transparent"] 2/16/2016 [/TD]
[TD="width: 66, bgcolor: transparent"] 2016 - Q1 [/TD]
[TD="width: 54, bgcolor: transparent"] Medical [/TD]
[TD="width: 72, bgcolor: transparent"] Outpatient [/TD]
[TD="width: 48, bgcolor: transparent"] R002 [/TD]
[TD="width: 126, bgcolor: transparent"] Palpitations [/TD]
[TD="width: 44, bgcolor: transparent"] 93229 [/TD]
[TD="width: 25, bgcolor: transparent"] 9 [/TD]
[TD="width: 56, bgcolor: transparent"] 9358036 [/TD]
[TD="width: 70, bgcolor: transparent"] 2/16/2016 [/TD]
[TD="width: 72, bgcolor: transparent"] 2/16/2016 [/TD]
[TD="width: 66, bgcolor: transparent"] 2016 - Q1 [/TD]
[TD="width: 54, bgcolor: transparent"] Medical [/TD]
[TD="width: 72, bgcolor: transparent"] Outpatient [/TD]
[TD="width: 48, bgcolor: transparent"] R002 [/TD]
[TD="width: 126, bgcolor: transparent"] Palpitations [/TD]
[TD="width: 44, bgcolor: transparent"] 93229 [/TD]
</tbody>
I have a spreadsheet with 5,000 plus rows and many of the rows containduplicate data. What I am trying to do is if Column A has a duplicate thencompare the data in those rows and if the entire row is a duplicate to somehowidentify them from conditional formating or a formula like COUNTIFS.
Example: A3 and A4 are duplicates so I need to check tosee the remaining part of these two rows are identical.
Is this possible?
[TD="width: 56, bgcolor: transparent"] A [/TD]
[TD="width: 70, bgcolor: transparent"] B [/TD]
[TD="width: 72, bgcolor: transparent"] C [/TD]
[TD="width: 66, bgcolor: transparent"] D [/TD]
[TD="width: 54, bgcolor: transparent"] E [/TD]
[TD="width: 72, bgcolor: transparent"] H [/TD]
[TD="width: 48, bgcolor: transparent"] I [/TD]
[TD="width: 126, bgcolor: transparent"] J [/TD]
[TD="width: 44, bgcolor: transparent"] K [/TD]
[TD="width: 25, bgcolor: transparent"] 1 [/TD]
[TD="width: 56, bgcolor: transparent"]
Case Number
[TD="width: 70, bgcolor: transparent"]
Service From Date
[TD="width: 72, bgcolor: transparent"]
Service To Date
[TD="width: 66, bgcolor: transparent"]
Year
[TD="width: 54, bgcolor: transparent"]
REVIEW TYPE
[TD="width: 72, bgcolor: transparent"]
CASE TYPE
[TD="width: 48, bgcolor: transparent"]
DXC CODE
[TD="width: 126, bgcolor: transparent"]
DXC DESC
[TD="width: 44, bgcolor: transparent"]
PXC CODE
[TD="width: 25, bgcolor: transparent"] 2 [/TD]
[TD="width: 56, bgcolor: transparent"] 9351528 [/TD]
[TD="width: 70, bgcolor: transparent"] 9/22/2016 [/TD]
[TD="width: 72, bgcolor: transparent"] 9/22/2016 [/TD]
[TD="width: 66, bgcolor: transparent"] 2016 - Q3 [/TD]
[TD="width: 54, bgcolor: transparent"] Medical [/TD]
[TD="width: 72, bgcolor: transparent"] Outpatient [/TD]
[TD="width: 48, bgcolor: transparent"] I4891 [/TD]
[TD="width: 126, bgcolor: transparent"] Unspec atrial fibrillati [/TD]
[TD="width: 44, bgcolor: transparent"] 93228 [/TD]
[TD="width: 25, bgcolor: transparent"] 3 [/TD]
[TD="width: 56, bgcolor: transparent"] 9351605 [/TD]
[TD="width: 70, bgcolor: transparent"] 10/26/2016 [/TD]
[TD="width: 72, bgcolor: transparent"] 10/26/2016 [/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 54, bgcolor: transparent"] Medical [/TD]
[TD="width: 72, bgcolor: transparent"] Outpatient [/TD]
[TD="width: 48, bgcolor: transparent"] I480 [/TD]
[TD="width: 126, bgcolor: transparent"] Paroxysmal atrial fibril [/TD]
[TD="width: 44, bgcolor: transparent"] 33282 [/TD]
[TD="width: 25, bgcolor: transparent"] 4 [/TD]
[TD="width: 56, bgcolor: transparent"] 9351605 [/TD]
[TD="width: 70, bgcolor: transparent"] 10/26/2016 [/TD]
[TD="width: 72, bgcolor: transparent"] 10/26/2016 [/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 54, bgcolor: transparent"] Medical [/TD]
[TD="width: 72, bgcolor: transparent"] Outpatient [/TD]
[TD="width: 48, bgcolor: transparent"] I480 [/TD]
[TD="width: 126, bgcolor: transparent"] Paroxysmal atrial fibril [/TD]
[TD="width: 44, bgcolor: transparent"] 33282 [/TD]
[TD="width: 25, bgcolor: transparent"] 5 [/TD]
[TD="width: 56, bgcolor: transparent"] 9352003 [/TD]
[TD="width: 70, bgcolor: transparent"] 1/9/2017 [/TD]
[TD="width: 72, bgcolor: transparent"] 1/10/2017 [/TD]
[TD="width: 66, bgcolor: transparent"] 2017 - Q1 [/TD]
[TD="width: 54, bgcolor: transparent"] NULL [/TD]
[TD="width: 72, bgcolor: transparent"] Outpatient [/TD]
[TD="width: 48, bgcolor: transparent"] R008 [/TD]
[TD="width: 126, bgcolor: transparent"] Other abnormalities of h [/TD]
[TD="width: 44, bgcolor: transparent"] 33282 [/TD]
[TD="width: 25, bgcolor: transparent"] 6 [/TD]
[TD="width: 56, bgcolor: transparent"] 9353964 [/TD]
[TD="width: 70, bgcolor: transparent"] 11/7/2016 [/TD]
[TD="width: 72, bgcolor: transparent"] 11/7/2016 [/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 54, bgcolor: transparent"] Medical [/TD]
[TD="width: 72, bgcolor: transparent"] Outpatient [/TD]
[TD="width: 48, bgcolor: transparent"] R002 [/TD]
[TD="width: 126, bgcolor: transparent"] Palpitations [/TD]
[TD="width: 44, bgcolor: transparent"] 93228 [/TD]
[TD="width: 25, bgcolor: transparent"] 7 [/TD]
[TD="width: 56, bgcolor: transparent"] 9353977 [/TD]
[TD="width: 70, bgcolor: transparent"] 11/23/2016 [/TD]
[TD="width: 72, bgcolor: transparent"] 11/23/2016 [/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 54, bgcolor: transparent"] Medical [/TD]
[TD="width: 72, bgcolor: transparent"] Outpatient [/TD]
[TD="width: 48, bgcolor: transparent"] R002 [/TD]
[TD="width: 126, bgcolor: transparent"] Palpitations [/TD]
[TD="width: 44, bgcolor: transparent"] 93228 [/TD]
[TD="width: 25, bgcolor: transparent"] 8 [/TD]
[TD="width: 56, bgcolor: transparent"] 9358036 [/TD]
[TD="width: 70, bgcolor: transparent"] 2/16/2016 [/TD]
[TD="width: 72, bgcolor: transparent"] 2/16/2016 [/TD]
[TD="width: 66, bgcolor: transparent"] 2016 - Q1 [/TD]
[TD="width: 54, bgcolor: transparent"] Medical [/TD]
[TD="width: 72, bgcolor: transparent"] Outpatient [/TD]
[TD="width: 48, bgcolor: transparent"] R002 [/TD]
[TD="width: 126, bgcolor: transparent"] Palpitations [/TD]
[TD="width: 44, bgcolor: transparent"] 93229 [/TD]
[TD="width: 25, bgcolor: transparent"] 9 [/TD]
[TD="width: 56, bgcolor: transparent"] 9358036 [/TD]
[TD="width: 70, bgcolor: transparent"] 2/16/2016 [/TD]
[TD="width: 72, bgcolor: transparent"] 2/16/2016 [/TD]
[TD="width: 66, bgcolor: transparent"] 2016 - Q1 [/TD]
[TD="width: 54, bgcolor: transparent"] Medical [/TD]
[TD="width: 72, bgcolor: transparent"] Outpatient [/TD]
[TD="width: 48, bgcolor: transparent"] R002 [/TD]
[TD="width: 126, bgcolor: transparent"] Palpitations [/TD]
[TD="width: 44, bgcolor: transparent"] 93229 [/TD]
</tbody>