Automatically find cell based on Pivot Table

[some_evil]

Hi All,

I have got a pivot table that is reading data that looks like this:
Microsoft Excel - WaterPressures.xlsx_2014-03-11_14-44-21.jpg

And the Pivot currently looks like this:
Microsoft Excel - WaterPressures.xlsx_2014-03-11_14-48-51.jpg

I have the Pivot showing me the Maximum and Minimum of two columns, and I am wanting to view what property ID that this maximum and Minimum refers too. Is this able to be done?
Microsoft Excel - WaterPressures.xlsx_2014-03-11_14-45-29.jpg

The spreadsheet can be found right here

Thanks

[MarvinP]

Hey Some...

Find attached your answer. I made some Helper Columns in your data so it would be easier for me. Then I used an Index Match to get your answers. See the attached. I had to chop off a few thousand rows to make it fit on the board. The answer is good but I removed some of your data at the bottom.

[some_evil]

Find attached your answer.

I am such a n00b, I cannot seem to find the attachment?

Cheers

[MarvinP]

My fault. The file was too big to post. I deleted about 2000 rows off the bottom and then it would fit. The formulas are the same....

See if you get what I did.

[some_evil]

Thanks Marvin, that works a treat... I would never have worked that out myself, but seeing the solution makes perfect sense!

Cheers