Hi all,
I have a Google Sheet file that I'd like to bring offline to Excel. I am using Excel 2016.
There are a few columns which show up as an error. I'm aware that (arrayformula... doesn't work in Excel 2016. I've tried to shorten the formulas, but what I have tried is either incorrect or showing up as errors.
I'm unable to include the Google sheet link here (first time posting), but the formula I am having issues to convert is as follows:
Summary Sheet:
Columns: J and K
=iferror(INDEX(arrayformula(filter(Transactions!O:O,Transactions!C:C<>"",row(Transactions!C:C)=max(if(Transactions!C:C=B2,row(Transactions!C:C),0)))) ,1),0)
Columns: O and P
=arrayformula(sumproduct(Transactions_OSV!C:C=B2,Transactions_OSV!B:B="Sell",Transactions_OSV!P:P))
Transactions Sheet:
Columns I and L
=iferror(if(row()<>2,INDEX(arrayformula(filter($J1:$J$2,$C1:$C$2<>"",row($C1:$C$2)=max(if($C1:$C$2=C2,row($C1:$C$2),0)))) ,1),0),0)
The excel workbook, is attached. Apologize in advance if the workbook is a bit laggy. I think its because of the dummy functions in the excel...
Any help is much appreciated!!
Bookmarks