Column A | Column B | Unique List with formula | Autofilter | ||
1 | 60122001 | 702995 | 702995 | ||
2 | 60122005 | 60122112 | 60122112 | ||
3 | 60122007 | 60122005 | 60122005 | ||
4 | 80112356 | 1458740 | 1458740 | ||
5 | 60122011 | 60122001 | 60122001 | ||
6 | 60122013 | 60122033 | 60122033 | ||
7 | 60122015 | 60122035 | 60122035 | ||
8 | 60122035 | 60122043 | 60122043 | ||
9 | 60122055 | 1234597 | 1234597 | ||
10 | 60122075 | 60122003 | 60122003 | ||
11 | 60122095 | 60122013 | 60122013 | ||
60122007 | |||||
80112356 | |||||
60122011 | |||||
60122015 | |||||
60122055 | |||||
60122075 | |||||
<colgroup><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>
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