It worked fine in my computer.
It's odd, if there is an error, error msg will be displayed in the cell
rather than the formula you entered.
Are you sure there is no space in front for the equal sign and/or after IF?


"Phil" wrote in message
...
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.