Compare cells and return occurrences

[emm8080]

Hi

I need a function that compares two columns of numbers and returns o
sorts numbers in column A that do not occur in column B

A B

1 1
2 3
3 3
4 4

The result would be 2.

Thx

Emm

 

[Norman Harker]

Hi Emma!

Take a look at:

Chip Pearson:
http://www.cpearson.com/excel/duplicat.htm#ExtractingUnique

All you need to know about unique and duplicate entries.