function to locate a number from a column of numbers

[basictypeuser]

I am trying to locate a series number from different columns.

Example:
Column A Column B Column C
2102 2101 2101
2104 2103 2103
2105 2105 2106
2107 2106

What I would like to do is if a nummber from column B does not exist in column A, then start an acsending list of these numbers in column c

Thanks,

 

[SkipVought]

Hi,
[tt]
=IF(ISNA(MATCH(B1,A:A,0)),B1,"")
[/tt]
Paste and copy down in column C.

Copy column C and Paste Special in column C with Values

Sort column C to eliminate empty rows

Skip,
[sub]
[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it! [/sub]

 

[basictypeuser]

Works great

Thks!!!