Forum Discussion
Solved
Last Dividend Transaction
Hi Guys, hope to get some help around here. I am trying to return the last Div transaction from the worksheet Transactions to HoldingsDB. A B C ...
You are welcome. Sorry the first formula was missing the "Div" condition.
=INDEX('Transactions to HoldingsDB'!$D$1:$D$3,MATCH(LARGE(IF(('Transactions to HoldingsDB'!$C$1:$C$3=HoldingsDB!A5)*('Transactions to HoldingsDB'!$B$1:$B$3="Div"),'Transactions to HoldingsDB'!$A$1:$A$3),1),'Transactions to HoldingsDB'!$A$1:$A$3,0))You can try this formula which takes into account the Type criteria "Div".
=INDEX('Transactions to HoldingsDB'!$D$1:$D$3,MATCH(LARGE(IF('Transactions to HoldingsDB'!$C$1:$C$3=HoldingsDB!A5,'Transactions to HoldingsDB'!$A$1:$A$3),1),'Transactions to HoldingsDB'!$A$1:$A$3,0))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
worksheet HoldingsDB:
worksheet Transactions to HoldingsDB:
- Hi! Thank you very much for your help. The formula almost worked.
The only thing missing is the Type criteria, some of the stock is return the last Buy value.You are welcome. Sorry the first formula was missing the "Div" condition.
=INDEX('Transactions to HoldingsDB'!$D$1:$D$3,MATCH(LARGE(IF(('Transactions to HoldingsDB'!$C$1:$C$3=HoldingsDB!A5)*('Transactions to HoldingsDB'!$B$1:$B$3="Div"),'Transactions to HoldingsDB'!$A$1:$A$3),1),'Transactions to HoldingsDB'!$A$1:$A$3,0))You can try this formula which takes into account the Type criteria "Div".
- That worked perfectly, thank you for your help!
Cheers!
