Kinda a newbie to Excel formulas, so I hope someone can help!
I have a spreadsheet that contains all items purchased by a specific customer over the last several years, including the item number, date of the order and the price they paid at that time.
Since the customer has purchased some items multiple times and the price has changed, I'm trying to figure out a formula that will return the most recently paid price for that item. The only formula I can get to work is one that will return a cost paid for that item number, but it doesn't always seem to be the most recent cost.
Thanks.
Bookmarks