Unique items in column C when comparing B to A

Hi,

Im sure this should be easy but cant find how to do it so hope someone can help. How can I get the result below?

In column A I have a list of numbers e.g. 1,2,3,4,5,6

In column B I have a list of other numbers e.g. 1,2,4,7,8

In column C the result I am looking for is to only show numbers from column B which are not in column A i.e. result should show 7,8


Column A and B will only have each number once.

Thanks,

Tim

Administrative note

Welcome to the forum

missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

Hi,

One way in C1 copied down.

=IF(ISERROR(MATCH(B1,$A$1:$A$6,FALSE)),B1,"")