Forum Discussion
How to retrieve the latest unit cost
Hello, I am sharing a condensed version of a pricing file that lists from Cols A to C Item Codes and pricing by date. The goal is to retrieve the latest unit cost for a particular Item Code. Here is...
Hello Olufemi,
Thank you very much for sharing the new and improved formula. Instead of creating the unique item code list in Column F, am I able to adapt the Optional formula in Column H to point directly to the source Item Code List in Column B? The new formula should be looking at the intersection of the Order Date and Item Code to bring in the latest unit cost.
Hope this makes sense. Thank you.
Shams.
Here is a single cell dynamic formula.
=LET(ItemCode,UNIQUE(B2:B759),REDUCE({"Unique Item Code","Latest Unit Cost"},ItemCode,
LAMBDA(a,x,VSTACK(a,INDEX(SORT(FILTER(A2:C759,B2:B759=x),1,-1),1,{2,3})))))