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