Locating duplicate rows in Excel

[stylencia18]

Good afternoon:

I have 10,000 rows of data and I want to search for duplicate rows but I don't know how to.

Sample spreadsheet:


[TABLE="width: 96"]
<colgroup><col width="64" style="width: 48pt;" span="2"> <tbody>[TR]
[TD="width: 64, bgcolor: transparent"][TABLE="width: 775"]
<colgroup><col width="98" style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584;"> <col width="144" style="width: 108pt; mso-width-source: userset; mso-width-alt: 5266;"> <col width="132" style="width: 99pt; mso-width-source: userset; mso-width-alt: 4827;" span="2"> <col width="170" style="width: 128pt; mso-width-source: userset; mso-width-alt: 6217;"> <col width="167" style="width: 125pt; mso-width-source: userset; mso-width-alt: 6107;"> <col width="103" style="width: 77pt; mso-width-source: userset; mso-width-alt: 3766;"> <col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3181;"> <tbody>[TR]
[TD="width: 98, bgcolor: transparent"]Date[/TD]
[TD="width: 144, bgcolor: transparent"]Claim Number[/TD]
[TD="width: 132, bgcolor: transparent"]Patient Name[/TD]
[TD="width: 132, bgcolor: transparent"]Code[/TD]
[TD="width: 170, bgcolor: transparent"]Patient ID Number[/TD]
[TD="width: 167, bgcolor: transparent"]Date Bill Submitted[/TD]
[TD="width: 103, bgcolor: transparent"]Amount Billed[/TD]
[TD="width: 87, 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 1^stand 3^rd rows are duplicates. How do I find duplicates in 10,000rows of data?

In order to be a duplicate, the following column names must matchexactly: Date; Code; Patient ID Number

Thank you!!!


[/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]

 

[JoeMo]

Try Data>Data Tools>Remove Duplicates

There are known bugs with Remove Duplicates, but I think your data would not be susceptible.