I have a pivot table with various data such as Account, Date, AccName (rows) and Average Cost (column)

I lookup the MIN and MAX value of the Average Cost, but I want to show the AccName as well.
Normally that would be easy as matching the data and linking the appropriate column but AccName is not in its own column, it being a pivot table.

Is there an easy way to do this please?


Pivot Table as below:
ROWS
Account
Date
AccName

VALUES
Average Cost (avg sum)


Min and Max look at the Average Cost column (=MIN(B:B)) etc but I want to also show the Name associated with the matching MIN value found?

Any help would be appreciated please.

Thanks.