Pivot Table Min and Max

[SiGill1979]

Apologies if this has been asked before, but I can't find it anywhere.

Is there a way I can use a pivot table to get me the Min and Max Values and the matching value from the next column?

Basically I have a list of items and prices from suppliers. I need to look up the cheapest supplier and most dearest supplier. Can I do it using a Pivot Table? Its simple to get the Min and Max, but how do I match the supplier to the Min and Max?
Thanks

Simon

[sandy666]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[SiGill1979]

Capture.PNG

I have attached a picture of example data and desired outcome

[sandy666]

did you read post#2 ?

Attach a sample workbook (not a picture or pasted copy).

To attach an Excel file to your post,

• desensitize data
• remeber that your example should reflect structure and type of data and contain the result what you want to achieve (manually created if necessary)
• click Go Advanced,
• scroll down until you see Manage Attachments,
• click that and select Browse,
• select your file and click Open,
• click Upload and you will see your attachment below Upload Files from a website
• click Close this window,
• click Submit reply

After that you should see attachment in your post

[SiGill1979]

I have just attached it

[sandy666]

is that what you want?

[SiGill1979]

Afraid not, I only want to see the lowest for each, or the highest for each, I don't need to see the others.

Like it shows in my Desired Outcome

[sandy666]

If you are interested I can do that with PowerQuery (Get&Transform)