View Single Post
 
Old 08-24-2013, 05:56 PM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Pecoflyer, thanks for pointing me in this direction. I took this long to figure out how to make it work, not because your directions were wrong or even unclear but because I had to keep fooling with them them, many different ways ("why does it work when I do this but not when I do this? They seem equivalent"). The point, as you may already understand, was not for me to make it work, but to understand how it works.

I'm still having trouble with it, because sometimes I can make array arithmetic work without <Ctrl-Shift-Enter> and sometimes not. In the latter cases, the formula bar claims that it's working correctly (that the MATCH function is returning 2, for example), yet what's actually displayed in the worksheet is #N/A—unless I use <Ctrl-Shift-Enter>. I don't suppose you know why, by any chance?
Reply With Quote