checking duplicate in multiple column in VBA?

hi,

how can I add column 1,2,3 here instead of column 3 only?
I want to compare three column to get the unique value.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

awaiting for someone to help on this.

One way is to add, a new column at the begging & do the concatenate of 1,2,3 column & use that column and later on delete it(created column).

Is this good enough?

1) Strongly recommend not to use "str" as a variable name, since vba has Str function.
2) try change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Originally Posted by jindon

1) Strongly recommend not to use "str" as a variable name, since vba has Str function.
2) try change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Many many thanks, its perfect.

Please Login or Register  to view this content.

You are welcome and thanks for the rep.

Please mark the thread as "Solved".

Sure,I'm marking it as solved.