Find duplicate rows base on combination of two columns / replicating sumproduct formula

Hi,

I found the thread "Find count of Unique or Duplicate Values based on Concatenated values in 2 columns" which is very close to what I am trying to achieve also but I need to replicate the formula in VBA.

http://www.excelforum.com/excel-form...2-columns.html

I've attached a mock excel file to help try demo what I am trying to do


I'm trying to replicate a formula which looks like this:

Please Login or Register  to view this content.

But the equivalent in VBA so that I can loop through each row and if count duplicates is greater than one, action a particular macro for that row.

Below is an attempt I tried but raised an error. I've tried various other permutations of this but without success.

Please Login or Register  to view this content.

Any help would be very much appreciated.

Hi, sorry I should have pointed out I am not trying to delete duplicates but to highlight them by colouring in their cell red fill. Also this is part of a bigger automation project hence wanting to do it with vba rather than settling for sumproduct formula.

Also, it may be that I need to generalize this for n combinations of columns rather than just 2 columns.

Thanks Sixthsense.

That is one possibility, using formula based conditional formatting. However, the creation of columns C and D in the excel I mocked were for illustration purpose. In fact, I want to avoid writing these columns in my actual program. In my actual program I would have just the data columns A and B.

Still no quite there yet

1) It only highlights the second/last occurrence of the duplicate, I need to highlight both first and second, pairs of duplicate rows (all duplicate rows if more than two).

2) Need to learn how to replicate this in VBA

That's excellent thank you. But now the question arises how to implement that same formula using condition formatting (via VBA) or hard code the color using VBA.