Find MIN IF and MAX IF From Excel Pivot Table

Описание к видео Find MIN IF and MAX IF From Excel Pivot Table

http://www.contextures.com/excel-pivo... Visit this page for details, and to download the sample file.

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.

Комментарии

Информация по комментариям в разработке

Похожие видео