View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gtslabs gtslabs is offline
external usenet poster
 
Posts: 54
Default extract row number from Pivot Table Result

I have a pivot table that looks up data from the day, time, event.
The pivot table gets the max(event) for each day.
But I want to get the Time for each day that the max(event) occured.
So I figured if Ihave the rownumber I Can get the time stamp.
Can I retrieve this row number in the Pivot Table? This Max may repeat
over different days so a vlookup might not work.