Find MIN IF and MAX IF From Excel Pivot Table

In Excel, you can use array formulas to find MIN IF and MAX IF. For example, what was the lowest total order for the Carrot Bars product?

An easier way to find the lowest and highest values for a specific item, is to use a pivot table.

In this video, you'll see how to create a pivot table and show the list of products. Then, add the Total Price field, and see the highest and lowest order totals for each product.

[excelisfun]

Oh my heavens! Steal away. Actually, appropriate away!!! That is what is so amazing about our Online Excel Team: we all post stuff and learn from each other. I have appropriated all that I know from many of our awesome Online Excel Team teammates! I have learned much for you over the years! Thanks!!

[excelisfun]

Love the title!! It is so true: PivotTables are easy!

[tsehayneshyilkal]

Wonderful job, I wasted almost 2 days fixing this problem for very long weather data almost 125634 record data to get the max and min of the daily weather data. My data was every 10 minutes. Really I am happy. Cheers!!!

[amankumaniya]

Thank You so much Guys, you doing a great Job

love this trick so easy

[Luciano_mp]

Muito bom, grande tutorial, concordo com ExcelIsFun, aprendemos todos em conjunto.obrigado.

[contextures]

@ExcelIsFun Thanks! And I'm not really trying to steal any of your array formula business. ;-)

[saimikeds]

so what if you wanted to see the range of costs in the array and take the max - min...?

[anguschalmers]

can you then do a calculation within the pivot table to find the difference and have that data be included within the pivot table ?

[pipo]

Hi, how can I show Min numbers higher then zero. Show values as → More options → Summarize value by... Min... but it shows the zero's.... Any suggestions please? Thank you.

[letusplay]

hi, what if i want to find second largest and second smallest