getting the date/time value from Pivot table data source

Hello everybody

I have a data source with date/time and different values.

An example of the data I have is the following:

3/3/2019 11:15 | 23.3
3/3/2019 11:30 | 23.5
3/3/2019 11:45 | 24.5
...

The pivot table I already created for the different days has the maximum value for 3/3/2019 (let's say it was 24.5).

How would I be able to retrieve the date associated with the maximum value (in the example, I would like the value "3/3/2019 11:45").

FYI, I also have multiple columns with similar information in which I which the data retrieval needs to work as well, not just 1 column worth of data.

Thanks for your help

Hi, welcome to the forum

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

I have attached a sample workbook with two tabs, "rawdata" and "Pivot Table", being the relevant one. The desired outcomes of what I would like to see is in the "Pivot Table" tab.

Thanks

See if the following does what you want:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

There are #REF! errors in the refers to of each of the named ranges.
The #REF! errors need to be replaced with cell values. For example airtemp1 should have a refers to that reads: =OFFSET(rawdata!B$1,0,0,COUNTA(rawdata!$A:$A)-1,1)
Once that is accomplished then the formula may be changed to read: =IF(ISERROR(VALUE(LEFT($A2,1))),"",MOD(INDEX(date,AGGREGATE(15,6,ROW(date)/(airtemp1=B2)/(TEXT(date,"d-mmm")=$A2),1)),1))
Let us know if you have any questions.