Use the MIN function to find the employee with the lowest sales

Addicted To Cialis Medrol Packs Buying Viagra Over The Internet Bio Brite Sun Alarm Can Plavix Substitute For Coumadin Viagra And Affiliate Breast Augmentation Discussion Boards Natural Herb For Lasix Plavix And Inr Breast Enhancement Capsules Ultra Curves Estrogen Coral Calcium Supreme 240 Zelnorm Affects Birth Control Patti Labelle Clas Of The Choirs Benefit Of Coral Calcium Hgh Effects On Teens Buy Hgh Buy Hgh Buy Hgh Anoretic Cardura Medication Leukeran Pet Medication Levitra For Females Out Of Court Settlement For Viagra Prednisone Prescribing Lamictal Bipolar 1 Aleve Pregnancy Coumadin Anticoagulation Drug Interaction Cipro Zoloft And Sudafed Plavix And Aspirin Interactions Use Zovirax For Effective Herpes Treatment Medrol Dose Pack And Crohns Synthroid Hot Flashes Geodon Im Cialis Manufacturer Jewish Purim Cookies Squill And Lipitor Synthroid Destroys Thyroid Advil Or Motrin Atarax Prescribing Information Flonase For Kidney Stones Lotrisone Cr 30 Mg Cost Of Viagra In The Philippines Can I Take Prozac At Night Zoloft Cleft Palatte Benefit Of Coral Calcium 0a North Beach Pizza Soma San Francisco Viagra Over Counter Herb Valproic Depakote Hypothalmus Hoodia Tlc Lasix Veterinary Dose Of Tramadol Neurontin Use

In a company, employee sales are monitored. Columns B to E contain the sales for the first four months of the year. To determine which employee has the lowest monthly sales, use the MIN function.
The function’s return value is the smallest value in a set.

MIN(number1, number2, …)
number1, number2, …: From 1 to 30 numbers for which you want to find the smallest value. It is possible to use a cell reference; however, the cells must contain numbers or values that can be converted to numbers.

To determine the lowest monthly sales:

In a worksheet, copy the range A1:E10 shown below.
Select cells B12:E12 and type the following formula: =MIN(B2:B10).
Press Ctrl+Enter.

This tip is compatible with Excel 97, 2000, 2003 and 2007.

Article Information

2 Comments

Jon Peltier

1

Strictly speaking, this doesn’t identify the employee with the lowest sales, it identifies the lowest sales value. To identify the employee, you could use conditional formatting. Select B2:E10, go to Formatting menu > Conditional Formatting, choose Formula Is for Condition 1, and enter this formula:

=B2=MIN(B$2:B$10)

then click Format and pick a fill color to identify the lowest performer. Click Enter, and the lowest value in each column will be highlighted.
October 8th, 2008 at 7:50 am
Jon Peltier

2

Didn’t I comment already? This post looks very familiar.

This will not identify the employee with the lowest sales, merely the lowest sales value.

You could use conditional formatting to highlight this minimum value in the table. Select B2:E10, go to Formatting menu > Conditional Formatting, and select Formula for Condition 1. Enter =B2=B$12 or =B2=MIN(B$2:B$10) as yoour condition formula, and select a format to highlight this minimum, perhaps bold red text of light red background.
October 14th, 2008 at 7:53 pm