Hi,
I am attempting to set up an automated workbook that will (using formulae) do comparisons between two reports. As a starting point I need to identify a list of unique ID numbers as these vary from report to report.
I have two columns of ID numbers, one from each report, each ID is made up of letters and numbers. I want to compare these two columns of data and create from them one column of data on a new workbook that contains only the unique values.
For example:
ColumnA
2
5
4
9
8
7
1
ColumnB
2
5
9
3
6
8
7
11
Result should be:
2
5
4
9
8
3
7
1
6
11
Further details:
Each column contains approx 550 IDs but this will vary from report to report
The two columns are on seperate tabs of the same workbook
Each column will contain a handful of ID numbers that are not in the other column, the remainder will be the same
I am able to identify unique records using filters for each column individually but I want to do this across the two columns and have it pull out into a new column with no manual processing/checking.
Any advice/pointers will be much appreciated!
Bookmarks