I have attached a workbook with integers in sheet 1 and sheet 2 column A. I would like to search these columns and take all non duplicate numbers and put them in sheet 3 column A.
Example:
200
300
200
234
2345
In sheet 3 it would have the following:
200
300
234
2345
I don't want the duplicates. Any help would be helpful.
The range will be growing and shrinking as i go.
Bookmarks