Create one new column of unique data from two columns

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!

Hi Blake 7,

Thanks for your reply.

Can you explain what CSE means and what should be in cells F1:F2? The formula fails for me as these cells are blank in my workbook.

This doesn't seem to work, the result is a column of zeros. Can you give me more detail on how this formula works so I can understand it?