[TABLE="class: outer_border, width: 561, align: center"]
<colgroup><col><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD][/TD]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Unique List with formula
[/TD]
[TD][/TD]
[TD]Autofilter[/TD]
[/TR]
[TR]
[TD="align: right"]1
[/TD]
[TD="align: right"]60122001[/TD]
[TD="align: right"]702995[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]702995[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]60122005[/TD]
[TD="align: right"]60122112[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]60122112[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]60122007[/TD]
[TD="align: right"]60122005
[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]60122005[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]80112356[/TD]
[TD="align: right"]1458740[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1458740[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]60122011
[/TD]
[TD="align: right"]60122001[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]60122001[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]60122013[/TD]
[TD="align: right"]60122033[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]60122033[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]60122015[/TD]
[TD="align: right"]60122035[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]60122035[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]60122035[/TD]
[TD="align: right"]60122043[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]60122043[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]60122055[/TD]
[TD="align: right"]1234597[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1234597[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]60122075[/TD]
[TD="align: right"]60122003[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]60122003[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD="align: right"]60122095[/TD]
[TD="align: right"]60122013[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]60122013[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]60122007
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]80112356[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]60122011[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]60122015[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]60122055[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]60122075[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I want comparing 2 columns & extract unique records in column naming Unique List with formula as I have done it by using data ---> remove duplicates
I want this result without using VBA as well as advance filter... this is actually sample data I have Column A 18750 records & Column B 21856 records....
thanks in advance
<colgroup><col><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD][/TD]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Unique List with formula
[/TD]
[TD][/TD]
[TD]Autofilter[/TD]
[/TR]
[TR]
[TD="align: right"]1
[/TD]
[TD="align: right"]60122001[/TD]
[TD="align: right"]702995[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]702995[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]60122005[/TD]
[TD="align: right"]60122112[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]60122112[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]60122007[/TD]
[TD="align: right"]60122005
[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]60122005[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]80112356[/TD]
[TD="align: right"]1458740[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1458740[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]60122011
[/TD]
[TD="align: right"]60122001[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]60122001[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]60122013[/TD]
[TD="align: right"]60122033[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]60122033[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]60122015[/TD]
[TD="align: right"]60122035[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]60122035[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]60122035[/TD]
[TD="align: right"]60122043[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]60122043[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]60122055[/TD]
[TD="align: right"]1234597[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1234597[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]60122075[/TD]
[TD="align: right"]60122003[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]60122003[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD="align: right"]60122095[/TD]
[TD="align: right"]60122013[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]60122013[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]60122007
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]80112356[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]60122011[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]60122015[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]60122055[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]60122075[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I want comparing 2 columns & extract unique records in column naming Unique List with formula as I have done it by using data ---> remove duplicates
I want this result without using VBA as well as advance filter... this is actually sample data I have Column A 18750 records & Column B 21856 records....
thanks in advance