I have a sheet set up like such:
<tbody>
</tbody>
It goes on and on for 20,000 rows. What I need to do is extract the most recent cost by date for each item and then I need to extract the date when that last purchase was made for that item. I feel like its a simple formula that I can't think of.
Item No. | Purch Date | Cost |
Item 1 | 1/18/2016 | 12.4 |
Item 1 | 2/1/2016 | 11.12 |
Item 2 | 3/22/2016 | 43.2 |
Item 2 | 4/18/2016 | 55 |
Item 3 | 4/22/2016 | 100 |
Item 3 | 5/13/2016 | 125 |
Item 3 | 6/17/2016 | 300 |
<tbody>
</tbody>
It goes on and on for 20,000 rows. What I need to do is extract the most recent cost by date for each item and then I need to extract the date when that last purchase was made for that item. I feel like its a simple formula that I can't think of.
Last edited: