Please see the attached. Except for the last (re-aligned) 1 that formula returns what it should.I array entered it into J2, but when I then drag it down and across it produces:
8 8 2
8 8 2
The second, shortened formula produces:
8 8 2
8 8 2
2
Ideally it would return:
8 8 2
1 1 6
1 1 1
1 1 1
1 1 1
1
Edit
That is correct, and no you shouldn't have to do anything additionally for that "block" of BvD ID. Please understand that each "block" of BvD ID will need to be re-entered with appropriate ranges.If I understand correctly, array entering only requires me to press CTRL + SHIFT + ENTER once right? Initially I mean; when I enter the formula into J2. When dragging down and across I don't need to do anything additionally?
However if there is a way to change those ranges dynamically to fill all 110 blocks in one formula it will require modification to that formula and some helper columns.
I haven't considered it, yet. Do you want me to?
Bookmarks