i cannot convert a Google sheets array formula to excel365

[EzLedgers]

I have an investment portfolio worksheet that has to track the balance of units held and the accumulated cost of those units. You can go to my website and make a copy of the worksheet.

This formula tracks the accumulated units held by the stocks symbol - it is used in cell Y10 on the BK_CDN tab and also on the BK_US tab. - the formula is also used to track the accumulated cost of the investment. See Cell AC10

=if($D10="","",iferror(if(row()<>2,INDEX(arrayformula(filter($Z$7:$Z9,$D$7:$D9<>"",row($D$7:$D9)=max(if($D$7:$D9=D10,row($D$7:$D10),0)))) ,1),0),0))

I cannot get it to work in Excel365 - any suggestions or workarounds?

Thanks
Jonathan

[Pete_UK]

If you are using Excel 365 you do not need to array-enter the formula, so you just need to delete this:

arrayformula(

and the corresponding close-bracket )

Hope this helps.

Pete

[Jameswalter]

It seems you have used a user defined function in GS. Obviously, it is not recognised by Excel. and "array formula" isn't something Excel would recognise either. In addition to that, the expressions in the "filter" function aren't compatible with those for Excel either.