Thanks Biff,

How would I get it to work if my real data was in Column B and Column F,
instead
of A & B as per my initial example. I would like the unique list to be
displayed in Column I.

Also, there is no set length to the amount of numbers that are in both
Columns B and Column F.

Thanks!
Rob

"Biff" wrote:

Hi!

Try this:

Enter this formula in C1:

=MIN(A1:B4)

Enter this formula in C2 using the key combination of CTRL,SHIFT,ENTER (not
just ENTER):

=IF(MIN(IF(A$1:B$4C1,A$1:B$4))<C1,"",MIN(IF(A$1:B $4C1,A$1:B$4)))

Copy down until you get blanks.

Biff

"Rob" wrote in message
...
Hello,

I have two lists of numbers in different columns, and require Excel to
generate one column of unique numbers from both lists.

Example:
Column A Column B Column C
1 1
2 3
3 4
5 5

I would require Column C to generate a listing of unique numbers from both
Column A and Column B. In this example, Column C would generate the
list of (1,2,3,4,5).

THANKS!
Rob