I swear excel is fucking with me.

Use a formula to generate an array, all good.

Use same formula but passed into vba function, different set of data.

All of the ranges are hard set with $, if I use the formula in another cell the results are correct.

I hate Microsoft and my workplace for making me use this shit.