Hello,
I'm embarrased to have to even ask this, but I CANNOT get my array formula
=IF (COUNTIF (NAMES, ???)>1, "Duplicate", "")
BTW, NAMES is a named range in the spreadsheet.
to work. I followed the instructions carefully, and did the CTRL+ SHIFT +
ENTER at the same time, and it doesn't work. After I do the CTRL+ SHIFT +
ENTER it just shows the formula in the cell.
I am STUMPED.
What are the EXACT steps?
TIA.
Bookmarks