Merging to Lists into one Unique List
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
|