Trying to replicate a Google Sheets spreadsheet into Excel but can not as the formulae doesn't exist in Excel.
Any ideas how to achieve the same thing would be appreciated
=IF($B7="SELL",MIN(ARRAYFORMULA(IF(FILTER($L$3:$L7,$A$3:A7=A7)>=-SUMIFS(C$3:C7,A$3:A7,A7,B$3:B7,"SELL"),FILTER($F$3:$F7,$A$3:A7=A7)))),)
The Spreadsheet is quite complex and that particular line checks for a date when a particular Crypto that has been sold was bought.
As cryptos are bought and sold they are disposed of in a First In First Out basis and the spreadsheet keeps information on this and adjusts accordingly.
Thank You
Screen Shot 2020-12-28 at 3.16.32 pm.png
Bookmarks