Hi,
I have a table below:
Date Item Cost
1/1/2017 A 10
1/2/2017 A 20
1/3/2017 B 30
1/4/2017 B 40
A was last purchased on 1/2/17 so I would like to get the value 20.
B was last purchased on 1/4/17 so I would like to get the value 40.
How/what formula to use to achieve this? Thank you.
Sochenda
Bookmarks