Compare two columns, display all values in third column with no duplicates

[bfs3]

Hi,

I want to compare I8:I50 with J8:J50 and then display all the values starting in H8 but no duplicates.

For example:

List 1

A
B
C
D

List 2

A
C
D
F

NEW LIST

A
B
C
D
F

[Tony Valko]

Are there any empty cells in either range?

[bfs3]

Yes, there are

[ExceleratorExpert]

Hi bsf3,

Try this link (the formula solution) from Microsoft: http://support.microsoft.com/kb/213367

I did try Data tab / Sort & Filter group then "Advanced" but realised that you could not use this for non adjacent columns!

Hope this helps,

EE

[Tony Valko]

See this:

http://www.excelforum.com/excel-form...le-column.html

There's a link to a sample file.