Picking up last Value with multiple occurrences

Can anyone help me figure this out? It's in Google Sheets.
Picking up last Value with multiple occurrences
The questions are also in the google sheet and it includes a small example
Thank you.


https://docs.google.com/spreadsheets...it?usp=sharing

cell E3 formula

Formula:

Please Login or Register  to view this content.

Originally Posted by wk9128

cell E3 formula

Formula:

Please Login or Register  to view this content.

Thank you this worked perfectly

Originally Posted by tanasedn

Formula:

Please Login or Register  to view this content.

Thank you this worked as well. But I only have Microsoft Excel 2016 . Can you do something with the same function but can be useable in the previous versions of Microsoft Excel? Thank You very much :D

not for google sheet formula , pls try

Formula:

Please Login or Register  to view this content.

You're Welcome. Glad to help . Thank You for the feedback.

If you finally get a solution please mark your thread as SOLVED:
- Click Thread Tools above your first post,you will see the word PREFIX on the upper left, press the button to select [SOLVED] select "Mark your thread as Solved".
- you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help
was given. By doing so you can add to the reputation(s) of those who helped.

Originally Posted by tanasedn

You said is in Google sheets and is working there

nvm. thanks anyways :D

@alfie4030 You're Welcome. Glad to help . Thank You for the feedback and rep.