array function

T

Tom Ogilvy

when you edit the formula, you normally exit edit mode by selecting another
cell or hitting Enter. At this point, you should hit Ctrl+SHIFT+enter
instead. (SHIFT, not ALT)
 
Top