VBA Find Rows with Non-Unique Information

[Barklie]

Hi,

I am trying to identify rows in a table (Range A7:AD7445) that contain information that is not unique. Specifically, I want to test each row to see if the contents of its 1st Cell (Column A) are equal to the contents of any other row's 1st Cell. If someone knows a way to do this, please let me know.

The reason I need this is for pricing discrepancy work I am doing. Essentially, if products with the same product code (Column U) in the same region (Column AD) have the billing period (Column A), then they shouldn't have different prices (Column W). If they do have different prices, I am trying to highlight the entire row so I can investigate.

Thanks!

 

[Andrew Poulsom]

You can use this formula in AE7 copied down:

=COUNTIF(A$7:A$7445,A7)>1