Proper way to enter array formula
Yep. That did it. I thank you both for your replies.
"JMB" wrote:
Check the cell format. If Text, change to General, then select the cell
w/your formula, hit F2 and Enter.
"Phil" wrote:
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.
|