Hi Excelforum
I am using google sheets and would like to solve the below issue. I need to pick the latest dividend from a column containing multiple numbers on the same ticker, but with different dates.
Can anyone help me out? - Please see attached an example of the issue.
Much appreciated.
Kind regards
Magnus
Hi Magnus415,
It messy but please try:
Formula:
Please Login or Register to view this content.
Hope this helps.
Hi D13L,
Thats amazing! Thank you very much :-)
Please try
=INDEX(VLOOKUP(H2:H4,{index(sort(A2:E,1,0),,2), SORT({A2:E,IF(E2:E,E2:E,D2:D)},1,0)},7,0))
Hi Bo_Ry
Thank you for your reply.
For some reason I cant get this to work.
Would you mind putting it into this spreadsheet please?
Kind Regards
Magnus
Google sheet is not Excel.Originally Posted by Magnus415
Please share the editable google sheet link.
Hi,
Thats correct, my mistake.
Please see below:
https://docs.google.com/spreadsheets...910/edit#gid=0
=INDEX(VLOOKUP(H2:H4,{index(sort(A2:E,1,0),,2), SORT({A2:E,IF(E2:E,E2:E,D2:D)},1,0)},7,0))
change seperator
=INDEX(VLOOKUP(H2:H4;{index(sort(A2:E;1;0);;2)\ SORT({A2:E\IF(E2:E;E2:E;D2:D)};1;0)};7;0))
Hi,
Thank you very much for the help it works.
Kind Regards
Magnus
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks