CODEWITHSUNDEEP
excel
Angelina
Angelina

Reputation: 2265

Excel-find column1 & column2 duplicates in the table

I need to find duplicates for columns A and B. So for example, if I have these values:

COLUMN A   COLUMN B     CODE  ISQUAL     ISRET      ISEXP

1004679    R&DCHPClass   3    QUALIFIED  Retired    Non-expired
1004679    R&DCHPClass   2    QUALIFIED  Retired    Non-expired

I want to be able to see all of the Matching COLUMN A & COLUMN B .

Because column A and column B will be a composite key in DB later.

Is this doable in Excel?

Upvotes: 0

Views: 118

Answers (1)

Jerry
Jerry

Reputation: 71538

You can create a column and use a COUNTIF.

Create the column in cell G2 for example (for row 2) and put in the formula:

=COUNTIF(A:A, A2)

Fill the formula to the bottom.

The same for column B, in cell H2, use:

=COUNTIF(B:B, B2)

And fill to the bottom.

Apply a filter and all the results 2 and higher are those that appear more than once.

Upvotes: 2

Related Questions