Drag down array formula

[kingi]

Hi,

I have a formula, which returns multiple values horizontalty

Please Login or Register  to view this content.

Is there any way to drag down this formula for the whole table?

Thanks in advance!

[Lemice]

Hello,

I'm pretty sure after you Ctrl-Shift-Enter your Array formula, you can copy paste it and paste it on as many rows as you want (excluding the current row of that formula).
It should have the same effect as dragging down (select the cell with formula, drag the small box in the lower right corner of the cell down / up / left / right)
If you are still having trouble, can you provide a small sample file?

[kingi]

Look at the attached file
excelforum.xlsx

Thanks!

[Lemice]

Not sure what you wanted, but you did a slight mistake there - it should have been $H25 instead of $H$25 in your formula.
Here is the sample file.

[kingi]

Thank you so much.
Sometimes we just need to look at the little things.