Hi,
if i have a list of two (or more) items, which i wrote next to them (in a different cell) the purchase date and the amount.
on a different cell i want to write a date to get all the purchases made that chosen date.
if i haven't bought one or more items on that date i still want it to show the last purchase of an item.
example (this is my list):
(item - date - amount)
apples - 01/05/2016 - 1
apples - 02/05/2016 - 7
apples - 03/05/2016 - 2
cherry - 01/05/2016 - 3
tomato - 01/05/2016 - 1
tomato - 02/05/2016 - 3
if i write down:
01/05/2016, i want it to show:
apples - 1
cherry - 3
tomato - 1
but if i write down 03/05/2016, i want it to show:
apples - 2
cherry - 3
tomato - 3
(the two last items on the list haven't been purchased on 03/05/2016 but it shows the data from closest purchase date)
the question is: what is the formula to finding the last closest date for each item.
(i have the item list ready - i don't need to find the items).
thank you very much
Bookmarks