I have a spreadsheet with three columns that contain ID numbers. I need to identify how many ID numbers that appear in column A also appear in column C but DO NOT appear in column B.
I'm struggling to work out how to do this. Could anyone advise on what kind of formula I should use to do this? I'm normally pretty good at working these things out so if someone could give me a gentle push in the right direction it would be appreciated.
Thanks.
I'm struggling to work out how to do this. Could anyone advise on what kind of formula I should use to do this? I'm normally pretty good at working these things out so if someone could give me a gentle push in the right direction it would be appreciated.
Thanks.