I have two lists on two different worksheets.
Old list is the previous list of names and the New list is an updated list of names. I want to be able to see what has changed between the two worksheet lists.
I have tried to use COUNTIF but not sure if I am using it correctly because it shows the entire new list as not existing in the old list.
Could someone guide me the right direction?