Hi Guys, I am looking for a formula rather than VBA to compare 2 lists and return a value.
I want to compare List B to List A and return the number of New Values in List B. (Answer should be 5).
It cant be just be a count of List A v List B as it is possbile that some of the items might be deleted from list b.
I can get around it by adding in an extra column, do a vlookup and then count the number of "false" values but would prefer not to add the extra column as I am only intested in the final number.
I hope that makes sense, can anyone help please?