Hoping someone on here knows their excel fairly well..
Although, i dont think this is that difficult, i just cannot get it to work.
Basically - i have 2 lists of numbers. I want to compare the numbers in column A with the numbers in column B - to see which are not there.
Ive tried a couple of Vlookups and some =IF sums.. but nothings working..
example ofnumbers are as below. theres about 100 in total.
Is there a formula i can use to do this? - ideally to show either the number that is not present in column C or a 'false' label...
Id rather not use Macros