Finding Duplicqates and Identifying Them

[srmorgan]

I have a table with 15,000 rows and 5 columns, R to V.
I should not have duplicate records and if I do, I have to find out why they are in my data.

When I run "duplicate values' for a match on all columns, the program deletes 10 records.
How do I figure out which rows are being eliminated?

Can I use conditional formatting to show where a row exactly matches the row above or below it?

All suggestions will be appreciated.

Thank you


SRM

 

[Fluff]

What is the code that you are currently using?

 

[srmorgan]

I haven't tried anything I am stumped where to begin

 

[srmorgan]

I have tried conditional formatting in two columns, R and V, at the same time and can't find anything, but then I am eyeballing 15,000 rows and it is hard to spot ten duplicates.
I have the table sorted by column r which is a unique patient account # and it shows matches but no matches in column V (my amount of the records)

 

[Fluff]

You said

When I run "duplicate values' for a match on all columns, the program deletes 10 records.

What is "duplicate values"?

 

[srmorgan]

Ok, sorry for not being clearer.
I am trying conditional formatting, I have a formula =(r2=r3) and I am applying it to $R:$v. I get duplicate values in many columns and many rows as expected. I would like to show only rows which match in all five columns.
I would them sort on color and identify the records that way.

Thanks

 

[srmorgan]

I think I figured out how to do it with a +IF(AND) formula.
Thanks

 

[Zenwood]

Try =IF(AND(R5=S5,S5=T5,T5=U5,U5=V5),TRUE)