| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 | |||
Hybrid Mode
