Copy duplicate rows from 2 columns Excel VBA

Question

I have a worksheet with 3 columns (A,B,C).

I want to check for duplicates between column A and C If a cell value in A matches a cell value in C then I want to copy B in that row to another location (let's say column E).

The cells are located in different rows on columns A and C. The copy from B column needs to be on the same row as the duplicate on A, not on C.

How can I do this with Excel VBA? Thanks a lot!

Try this =IF(COUNTIF($A$1:$A$1,C1)>0,B1,"")

0m3r
– 0m3r

2015-06-27 00:24:56 +00:00
Commented Jun 27, 2015 at 0:24 — 0m3r
– 0m3r, Commented Jun 27, 2015 at 0:24

Eric Aya · Accepted Answer · 2015-06-27 11:08:32Z

1

Perhaps you can use a formula like:

=IF(COUNTIF(C:C,A1)>0,B1,"")

It should give you what you want. Put that in column E, and copy it down for what you need.

edited Jun 27, 2015 at 11:08

Eric Aya

70.2k36 gold badges190 silver badges266 bronze badges

answered Jun 27, 2015 at 0:18

Ryan Wildry

5,6971 gold badge17 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Copy duplicate rows from 2 columns Excel VBA

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related