View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gaurav[_2_] Gaurav[_2_] is offline
external usenet poster
 
Posts: 207
Default Pivot table: Most recent price for an item?

I can tell you a formula that can return the last value entered in a row or
column. Will that work for you?


"Pierre" wrote in message
...
Have lots of sales data, and would like to have a column display the
most recent price for an item.
Source data includes many shipments for various items, along with cost
and burden figures.

How might I populate within the pivot table, a column which gives the
most recent price for the item in that row?

TIA for thoughts.
pierre