Problem - I have to sift through a large table of sales data and find the most recent selling point for each SKU. Here is what I have to work with:
Column A - SKU
Column B - Sale # (integer values 1, 2, 3....) highest value = most recent sale
Column C - Selling Price
Basically I need to find the largest value in column B per SKU, then return the SKu, Price for that row
Thought I could do this with Subtotal using "For each change in SKU find MAX of column B" but that doesn't show me the price that corresponds to the row which contained the highest value in B.
Seems like such a simple problem...
Bookmarks