Highlighting Rows where Data is Duplicated in More than One Cell

any row where data in Column A and data in Column B is identical.

Do you mean that in that row, the value in column A is the same as the value in column B?

This can be done with conditional formatting. But I'm not sure I understand your description, because

There are many instances where data in just one of the columns would be duplicated

Now it sounds like you are checking to see if data in that row appears in another row.

So can you define more clearly your definition of what you want to highlight? A concrete example would be best, and the best of all would be to attach a file with an example showing the result you want.

Hello Beese,

Welcome to the Forum!

You could use Conditional Formatting, as shown in the attached sample Workbook.

Regards.

@ 6StringJazzer,

Hi Jeff,

Its been a while since we have had contact. The OP also states;

There are many instances where data in just one of the columns would be duplicated, but it wouldn't necessarily be a duplicate entry unless both columns have the same data.

Or am I missing something?

Regards.

Please Login or Register  to view this content.

@ JLGWhiz,

If you want to use VBA instead of the built in Excel Conditional Formatting, then this will work;

Please Login or Register  to view this content.

As opposed to your formula;

Formula:

Please Login or Register  to view this content.

Regards.

Originally Posted by Winon

@ JLGWhiz,

If you want to use VBA instead of the built in Excel Conditional Formatting, then this will work;

Please Login or Register  to view this content.

As opposed to your formula;

Formula:

Please Login or Register  to view this content.

Regards.

I didn't get the same results. It only identified items where column A matched column B. I think the OP wanted to find duplicates where count of column A value is greater than 1 and the value in column B is the same as the value in the first occurrence column B value. In otherwords, Column A and B might not be the same value but the concatenated values of the two could be the same on more than one row. But you are correct that it could be done with CF.

But maybe I read the OP wrong.

@ JLGWhiz,

Your assumption may be correct, but I found that your Code, erases the Data in Column A on completion.

Regards.

Originally Posted by Winon

@ JLGWhiz,

Your assumption may be correct, but I found that your Code, erases the Data in Column A on completion.

Regards.

Yes, it deletes the helper column that was added at the beginning of the macro, but it does not delete any of the original data.

It woud be nice if the OP would respond and let us know what they really want.

Then Post #6 will work with changes to accomodate the column layout in your screen shot.

Please Login or Register  to view this content.

The way I would word this is to highlight any rows where the combination of column B and column C are duplicated in other rows.

The simplest way to do this is with conditional formatting:

Formula:

Please Login or Register  to view this content.

Sample attached. I didn't take the time to type in your actual post codes (I suggest you attach a file instead of an image next time) but otherwise matches your examples.