I have this formula:
in an Excel Spreadsheet. When I try use AutoFill to get this thing into the rows
and columns next to it, it only partially works. Sometimes I can pull it across 16 rows, sometimes only three or four. Sometimes I can only pull it down to row 98 and it refuses to go any further–no error message or anything, it just doesn’t work. Further, when I get to row 98, I tried to manually type the formula into row 99 --it vanished as soon as I hit enter. No error, just nothing in the cell any longer. I have other simpler formulas in the cell (like a simple =sum formula), and I can auto fill those to my heart’s content. The only thing different I see is that the one is an arrray formula–why should this affect my ability to use autofill? And how the hell does it decide where to stop? It doesn’t stop at the same spot every time.
To complicate matters—a nearly identical array formula appears elswhere in the spreadsheet (the only difference being the last part says =6 instead of =5), and while I had no problem getting it to fill to every cell I needed, just for fun I tried to see if I could make it go further than I needed–and it won’t anymore.
Anyone know what the heck is going on??