Find duplicate rows

[Kyrre]

I have figured out how to remove duplicate rows, but not how to hilight theme.
Look into example workbook. It is some duplicates there.
I hope someone can save my day and show me the way.

 

[Chihiro]

Select range A2:D41. Go to Conditional Formatting and choose "Use a formula to determine which cells to format".

Enter below formula and apply your formatting.
=COUNTIFS($A$2:$A$41,$A2,$B$2:$B$41,$B2,$C$2:$C$41,$C2,$D$2:$D$41,$D2)>1

 

[Kyrre]

Select range A2:D41. Go to Conditional Formatting and choose "Use a formula to determine which cells to format".

Thanks a lot for helping me out. Could u please post book with formula? BEcause of my norwegian language, it is trouble with translation.

 

[Chihiro]

Here you go.

 

[Kyrre]

Here you go.

It worked, but I got errormessage when i used copy paste. I have 2000 rows to check, so it is a bit annoying,.,.
Does picture show correct place to add formula?

 

[Chihiro]

Yes. But you will need to edit the range of the formula. As it only checks for existing data on your sample sheet.

 

[Kyrre]

Yes. But you will need to edit the range of the formula. As it only checks for existing data on your sample sheet.

I tried to paste formula , but got error message. I used same sheet as u have, but without formula. However, thanks a lot. I will figure it out!

 

[Chihiro]

Oh, depending on language. You may need to replace "," with ";".

 

[Kyrre]

Oh, depending on language. You may need to replace "," with ";".

It was syntax error in my brain,.,. I figured it out! Thanks a lot