I have data in my excel sheet in the below format

A B

1 2

2 3

3 5

4 8

5

6

7

8

9

i.e colA has values 1 through 9 and colB has 2,3,5,8. Now what I need in col C is, the data in colA which is not there in colB .

So my result column C should have

C

1

4

6

7

9

Can anyone help me out how to achieve this?

Thanks