Having trouble entering arrays in Excel online

[Ellwood]

Hi all -
I just joined the forum and have need of assistance.

I am required to use Excel Online (Office 365) at work. I am creating a spreadsheet to assist with daily inventory tasks, and one worksheet uses several iterations of the same array.
When I first entered the formula in my first iteration and hit 'Enter', Excel automatically added the brackets and the array was extended for 6 cells downward. I then copied and pasted the formula, made the necessary reference changes, and hit 'Enter' again, and all the entries worked as before, with Excel automatically adding the brackets.

However, recently I had need to expand the number of iterations, so I again copied and pasted the original array and hit 'Enter', but this time Excel did not add the brackets and did not generate a new array. When I went back to the original array, wrote the original formula in the first cell of the array and hit 'Enter', it would not add the brackets and would not generate the array. By backing up a couple of steps I was able to save the array, so at least the first 32 iterations still work fine.

The original array formula looks like this: {=IFERROR(SMALL(IF('RAW DATA'!$H$4:$H$1000=B$3,ROW('RAW DATA'!$H$4:$H$1000)),ROW(1:1)),"")}.
When I copy and paste the formula and make the necessary reference changes it looks like this: =IFERROR(SMALL(IF('RAW DATA'!$H$4:$H$1000=B$333,ROW('RAW DATA'!$H$4:$H$1000)),ROW(1:1)),"") but will no longer generate the brackets or a new array no matter where I try to enter it on the worksheet.



I know I must have done something weird to prevent me from continuing my array iterations, but I cannot figure out what I did. Can anyone help? My job may depend on finding the right answer (just kidding!)

Thanks for any help.

I don't know how to attach a sample spreadsheet, and since the formula indirectly accesses seven different Worksheets I'm not sure I could post one that would work.

- Ellwood

[leblebiber]

Array formulas need to be array entered. This means instead of hitting "enter" you need to hit "ctrl+shift+enter".

Right after you paste your copied range, with your entire range still highlighted, place your cursor in the formula bar and hit ctrl+shift+enter

-Leblebiber

[Ellwood]

Excel online will not allow the use of "ctrl+shift+enter". The online version looks at your formula and automatically determines if it will generate an array or not, and automatically adds the brackets.
As I said in my post, the first 32 iterations of my array generated perfectly. Since then I cannot add another array. I have tried numerous times to use the "ctrl+shift+enter" technique but the system will not allow it.

[leblebiber]

ah, sorry about that, missed the "online" part...