UDF array function doesn't return array

I'm trying to create that would resample a range by basically repeating values gain. For example {1,2,3} would become {1,1,2,2,3,3}. For some reason my function only returns 0 all the time. Can someone help?

Please Login or Register  to view this content.

If you are outputting to the cells, how are you entering the formula?

You need to select few cells (3 or 4 or even more) and enter the formula and confirm with ctrl + shift + enter.

Yeah, I tried to do it that way but it just returns "0" several times. Weird thing is that if I make it return say upArray(3) to see if it creates the array the correct way it works and shows the correct value. Only when I try to get it return the whole array it breaks.

Aren't you try to outputting vertically?
If so, the formula should look like
=transpose(test(a1:a5,3))
and confirm with ctrl + shift + enter.

Ah, this helped. Thank you!

And change to

Please Login or Register  to view this content.

Otherwise you will always get 0 in the first cell unless you declare Option Base 1.