| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
That was it..... Thanks for the help.
"bj" wrote: remove the "{" and "}" from the cell and then use the control-shift-enter if you typed in the { and } it thinks it is text. If you are getting an error message, what is the message? "Alex" wrote: I just tried that but had no luck. Could it be a setting? This is the formula {=INDEX(Q1:Q54,SMALL(IF(Q1:Q54<" ",ROW(V1:V54)),ROW(6:6)))} "bj" wrote: from {your} title I asssume the formula is an array formula It needs to be entered with control-shift-enter "Alex" wrote: About a year ago I got a formula from this site and was told that when I hit enter I needed to do something else to make it work. It worked great at the time but now I want to do it again and forget how. Can anyone help me? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
| Frequency formula | Excel Worksheet Functions | |||
| Multiple Condition Sumif Formula | Excel Worksheet Functions | |||
| Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Threaded Mode
