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.