Blog

Understanding sales performance is crucial for any business. Identifying the best and worst sales figures from a dataset can help businesses make informed decisions. Below is an example of how to create a simple sales performance analysis in Excel using the MIN and MAX functions.

Example

Here is an example of a sales dataset and how you can highlight the best and worst sales figures using Excel functions.

Exercise

Task: Create a similar table in Excel with the following sales data and identify the best and worst sales figures using the MIN and MAX functions:

Solution

In the exercise, the best sales figure is 10000 in November, and the worst sales figure is 3000 in October. The completed table should look like this:

Explanation

Use the MAX function to identify the highest sales figure:

=MAX(B2:B7)

Use the MIN function to identify the lowest sales figure:

=MIN(B2:B7)

Use an IF statement to populate the "Best/Worst Indicator" column:

=IF(B2=MAX($B$2:$B$7),"Best",IF(B2=MIN($B$2:$B$7),"Worst",""))

By identifying the best and worst sales figures, you can gain valuable insights into your sales performance, enabling you to make data-driven decisions.