i currently have two columns (e.g. A2:A400, B2:B20) and i am trying to match all the values in B to A, displaying TRUE or FALSE (if the values from B don't appear in A) in column C. i have tried using the various formula for duplicates, substituting what i thought would be the correct formula, but to no avail. i know this is super simple but it's very frustrating. please help.
L.
Bookmarks