Create Unique Value List from Two Columns in One Sheet to third Column

[ootkhopdi]

Hi,

i have a worksheet named "Sheet1"
in this sheet i have two lists in Column A and Column B

in both columns there are some Ids
some Ids are common in both Columns

i want to create a list of Unique Ids in Column C but without an arrey Formula

because Arrey Formula takes too much time in processing


plaese help me

how can i do it

 

[Pink Floyd]

Hi,

It's quite simple actually, create a new column C in which data in which first data in column A is pasted followed by data in column B. As a result, you now have a single column of data containing some duplicate values.

As next step, in the Excel ribbon, go to Data -> Data Tools -> Remove Duplicate. Select "Continue with the current selection" and press "Remove Duplicates". You should have what you are looking for.

Let me know if this works.

 

[ootkhopdi]

Thanks Pink

But i want a macro or code for this unique list