View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pierre Pierre is offline
external usenet poster
 
Posts: 193
Default Pivot table: Most recent price for an item?

On Jan 3, 2:24*pm, "Gaurav" wrote:
I can tell you a formula that can return the last value entered in a row or
column. Will that work for you?



Gauray, I'll have a go at it. (I was hoping for something within the
PT that would draw in the most recent date, as that would preclude the
reconstruction of the table if fields are added or changed at a later
time.)

Thanks.

Pierre