including is not blank in a function
Hi Wizards! I have a function to look for duplicate last names in a sheet; however, the cells will be blank as we start the project...it is returning "duplicate" in all of the blank cells which I don't want:
=IF(COUNTIFS([LAST NAME]:[LAST NAME], [LAST NAME]@row) > 1, "Duplicate")
I've tried to include IF([LAST NAME]<>""(rest of formula) but that is not working ...
Any help would be greatly appreciated!!!!