Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Proper way to enter array formula
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. |
#2
|
|||
|
|||
Proper way to enter array formula
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. |
#3
|
|||
|
|||
Proper way to enter array formula
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. |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Editing Array Formula | Excel Worksheet Functions | |||
Trouble shooting#NA error in Array formula | Excel Discussion (Misc queries) | |||
Help with array formula | Excel Worksheet Functions | |||
What instead of an array formula part 2 | Excel Discussion (Misc queries) | |||
how to enter a formula using column() function for a range | Excel Worksheet Functions |