highlight duplicate rows comparing two cells

P

pgcn

This post follows on from Dave Peterson's reply 13/3/08.
I replied twice on the 14th but they seem not to have posted.

Dave your code will be good if I want to just see unique values but
can I please get some help to highlight all rows where col C LastName
and col D FirstName are the same.
I don't want to concatenate and advance filter as I want to be able to quickly search all records >when deciding which duplicate to delete or to keep both/all (other columns
may differ).
Click to expand...

I need to be able to use the code again so was thinking that it would
be put in a module in my personal.xls?

thanks again
Peta
 
J

Joel

RowCount = 1
Do While Range("C" & RowCount) <> ""
If Range("C" & RowCount) = Range("D" & RowCount) Then
Rows(RowCount).Interior.ColorIndex = 6
End If
RowCount = RowCount + 1
Loop
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

highlight duplicate rows comparing two cells 3
Highlight Duplicate Rows (In Series) 4
delete rows that have a duplicate id keeping the upper row 6
Excel Heiarchy and Highlight rows where certain data lies 3
Sort Range and Sum/Delete Duplicate Rows 9
Comparing Rows 9
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
comparing rows 3

Top