stylencia18
New Member
- Joined
- Aug 14, 2017
- Messages
- 31
Good afternoon:
I have 10,000 rows of data and I want to search for duplicate rows but I don't know how to. I do NOT want to delete duplicates, just highlight them.
Sample spreadsheet:
[TABLE="width: 1"]
<tbody>[TR]
[TD="width: 777, bgcolor: transparent"]
[TABLE="width: 581"]
<tbody>[TR]
[TD="width: 83, bgcolor: transparent"]Date
[/TD]
[TD="width: 105, bgcolor: transparent"]Claim Number
[/TD]
[TD="width: 94, bgcolor: transparent"]Patient Name
[/TD]
[TD="width: 91, bgcolor: transparent"]Code
[/TD]
[TD="width: 121, bgcolor: transparent"]Patient ID Number
[/TD]
[TD="width: 124, bgcolor: transparent"]Date Bill Submitted
[/TD]
[TD="width: 82, bgcolor: transparent"]Amount Billed
[/TD]
[TD="width: 74, bgcolor: transparent"]Amount Paid
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]10/1/2014
[/TD]
[TD="bgcolor: transparent"]156161
[/TD]
[TD="bgcolor: transparent"]John Doe
[/TD]
[TD="bgcolor: transparent"]99213
[/TD]
[TD="bgcolor: transparent"]A615651
[/TD]
[TD="bgcolor: transparent"]10/5/2014
[/TD]
[TD="bgcolor: transparent"]$700.00
[/TD]
[TD="bgcolor: transparent"]$500.00
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]10/8/2015
[/TD]
[TD="bgcolor: transparent"]165511
[/TD]
[TD="bgcolor: transparent"]Sam Jones
[/TD]
[TD="bgcolor: transparent"]99214
[/TD]
[TD="bgcolor: transparent"]B625663
[/TD]
[TD="bgcolor: transparent"]10/15/2015
[/TD]
[TD="bgcolor: transparent"]$800.00
[/TD]
[TD="bgcolor: transparent"]$200.00
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]10/1/2014
[/TD]
[TD="bgcolor: transparent"]156161
[/TD]
[TD="bgcolor: transparent"]John Doe
[/TD]
[TD="bgcolor: transparent"]99213
[/TD]
[TD="bgcolor: transparent"]A615651
[/TD]
[TD="bgcolor: transparent"]10/5/2014
[/TD]
[TD="bgcolor: transparent"]$700.00
[/TD]
[TD="bgcolor: transparent"]$500.00
[/TD]
[/TR]
</tbody>[/TABLE]
We can easily see that the 1stand 3rd rows are duplicates. How do I find duplicates in 10,000 rows of data?
In order to be a duplicate, the following column names must match exactly: Date; Code; Patient ID Number
Thank you!!![/TD]
[/TR]
</tbody>[/TABLE]
I have 10,000 rows of data and I want to search for duplicate rows but I don't know how to. I do NOT want to delete duplicates, just highlight them.
Sample spreadsheet:
[TABLE="width: 1"]
<tbody>[TR]
[TD="width: 777, bgcolor: transparent"]
[TABLE="width: 581"]
<tbody>[TR]
[TD="width: 83, bgcolor: transparent"]Date
[/TD]
[TD="width: 105, bgcolor: transparent"]Claim Number
[/TD]
[TD="width: 94, bgcolor: transparent"]Patient Name
[/TD]
[TD="width: 91, bgcolor: transparent"]Code
[/TD]
[TD="width: 121, bgcolor: transparent"]Patient ID Number
[/TD]
[TD="width: 124, bgcolor: transparent"]Date Bill Submitted
[/TD]
[TD="width: 82, bgcolor: transparent"]Amount Billed
[/TD]
[TD="width: 74, bgcolor: transparent"]Amount Paid
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]10/1/2014
[/TD]
[TD="bgcolor: transparent"]156161
[/TD]
[TD="bgcolor: transparent"]John Doe
[/TD]
[TD="bgcolor: transparent"]99213
[/TD]
[TD="bgcolor: transparent"]A615651
[/TD]
[TD="bgcolor: transparent"]10/5/2014
[/TD]
[TD="bgcolor: transparent"]$700.00
[/TD]
[TD="bgcolor: transparent"]$500.00
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]10/8/2015
[/TD]
[TD="bgcolor: transparent"]165511
[/TD]
[TD="bgcolor: transparent"]Sam Jones
[/TD]
[TD="bgcolor: transparent"]99214
[/TD]
[TD="bgcolor: transparent"]B625663
[/TD]
[TD="bgcolor: transparent"]10/15/2015
[/TD]
[TD="bgcolor: transparent"]$800.00
[/TD]
[TD="bgcolor: transparent"]$200.00
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]10/1/2014
[/TD]
[TD="bgcolor: transparent"]156161
[/TD]
[TD="bgcolor: transparent"]John Doe
[/TD]
[TD="bgcolor: transparent"]99213
[/TD]
[TD="bgcolor: transparent"]A615651
[/TD]
[TD="bgcolor: transparent"]10/5/2014
[/TD]
[TD="bgcolor: transparent"]$700.00
[/TD]
[TD="bgcolor: transparent"]$500.00
[/TD]
[/TR]
</tbody>[/TABLE]
We can easily see that the 1stand 3rd rows are duplicates. How do I find duplicates in 10,000 rows of data?
In order to be a duplicate, the following column names must match exactly: Date; Code; Patient ID Number
Thank you!!![/TD]
[/TR]
</tbody>[/TABLE]