MIN and MAX functions in Excel - Dashboard Guide

Dashboard Mode - MIN and MAX functions

Dashboard Goal

Find the lowest and highest sales amounts from a list of monthly sales to quickly understand sales performance extremes.

Sample Data

Month	Sales
January	1200
February	1500
March	900
April	1800
May	1100
June	1600

Dashboard Components

• Minimum Sales (KPI Card): Shows the smallest sales value.
  Formula: =MIN(B2:B7)
  Result: 900
• Maximum Sales (KPI Card): Shows the largest sales value.
  Formula: =MAX(B2:B7)
  Result: 1800
• Sales Data Table: Displays the monthly sales data as shown above.

Dashboard Layout

+-------------------+-------------------+
| Minimum Sales: 900| Maximum Sales: 1800|
+-------------------+-------------------+
|                                   |
|        Sales Data Table            |
|                                   |
+-----------------------------------+

Interactivity

Add a filter to select specific months. When you choose months, the Minimum and Maximum Sales cards update to show the lowest and highest sales only for the selected months. The Sales Data Table also updates to show only the filtered months.

Self Check

If you filter the data to show only March, April, and May, what will the Minimum and Maximum Sales cards show?

Answer: Minimum Sales = 900 (March), Maximum Sales = 1800 (April)

Key Result

Dashboard shows the lowest and highest monthly sales from a sales list using MIN and MAX functions.