Here are the contents of my table:
ColA= date, ColB=Code #, ColC=Whole Amt, ColD=Amt as of now, ColE=Accumulated Amt
What i want to happen is to return the value from Column D and put it in Column E based on the latest date; however, the value of ColB value should be the same.
I tried using INDEX + MATCH + MAX, but something is missing and I can't point it out.
I am sharing here the link of the sheet so you can explore. I also put some comments beside each cell as it may help. Thank you!
https://docs.google.com/spreadsheets/d/1YADVkKPNp0TmSVtz6X9EtgqAnTNTocNBWFwtQzt5okE/edit?usp=sharing