Finding duplicate data

[tobor]

To whom it may concern,
Can anyone tell me is there a way to have excel automatically find and flag duplicate data? I get a report of about five hundred rows of orders, there should not be any duplicate but if I ask excel to remove duplicate it does. The problem is I don't know what was removed so I can't see what needs fixing.

Thanks in advance

 

[texasalynn]

how are you defining duplicates? A single column? But you have different data in various columns? Please post a sample

 

[tobor]

Follow up. One column has my order numbers. I can sort by that, if a duplicate order is found I would highlight it.

 

[Trouttrap2]

You could use conditional format.

Select the cells that you wish to test and format, B2:B64 in this example. Then, open the Conditional Formatting dialog from the Format menu, change Cell Value Is to Formula Is, enter the formula below, and choose a font or background format to apply to cells that are duplicates.

Enter =countif($b$2:$B$64,B2)>1