# Using MIN function in column with blanks

#### oldpup223

##### Board Regular
I have a scoring sheet that lists scores in a column but never know how many names will be entered and want to find the minimum score in a column with several blanks above the formula

### Excel Facts

Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

#### Yongle

##### Well-known Member
Which version of Excel are you using

This formula is simplest but it is not available in earlier versions
=MINIFS(C:C,C:C,"<>")

Excel 2016 (Windows) 32 bit
A
B
C
D
E
F
1
100​
10​
=MINIFS(C:C,C:C,"<>")
2
25​
3
4
50​
5
75​
6
25​
7
10​
8
100​
9
1100​
10
27​
11
100​
12
13
59​
14
77​
 Sheet: Sheet4

Last edited:

#### Yongle

##### Well-known Member
From your post, I assumed that the you had tried the obvious
=MIN(C:C)

That works for me and ignore blanks. Does it not work for you ?

#### oldpup223

##### Board Regular
Thank you for the reply. I have several rows with data (E through I) and in the row end in column (L) I have
a +MIN(E5:I5) and that works fine then at the bottom of column (L) I have another =MIN(L5:L105) and that will not work as there are many blanks between row 5 and 105 so either it woll not work because of the blank rows or you cannot use the min statement on a column of generated numbers by the min statement at the end of the rows. thank you for any help you may wish to give.

#### oldpup223

##### Board Regular
Thank you for the reply. I have several rows with data (E through I) and in the row end in column (L) I have
a +MIN(E5:I5) and that works fine then at the bottom of column (L) I have another =MIN(L5:L105) and that will not work as there are many blanks between row 5 and 105 so either it woll not work because of the blank rows or you cannot use the min statement on a column of generated numbers by the min statement at the end of the rows. thank you for any help you may wish to give

What is a in
a +MIN(E5:I5)

#### oldpup223

##### Board Regular
Thank you for the reply. I have several rows with data (E through I) and in the row end in column (L) I have

=MIN(E5:I5) and that works fine then at the bottom of column (L) I have another =MIN(L5:L105) and that will not work as there are many blanks between row 5 and 105 so either it will not work because of the blank rows or you cannot use the min statement on a column of generated numbers by the min statement at the end of the rows. thank you for any help you may wish to give

---End Quote---

#### Fluff

##### MrExcel MVP, Moderator
In what way is you formula not working?
Also are the blanks actually blank or do they show 0 as there is nothing in that row?

#### oldpup223

##### Board Regular
yes the cells are blank and after using =min(l5:l105) in cell l106 I just get a blank cell but the formula is still there

#### Fluff

##### MrExcel MVP, Moderator
Are you sure that your blanks are actually blank? Rather than contain a 0 that is hidden by formatting, or because you have unchecked "Show a zero in cells that have zero value"?

### Forum statistics

1,101,785
Messages
5,482,921
Members
407,367
Latest member
FunkyFriedChicken

### This Week's Hot Topics

• Finding issue in If elseif else with For each Loop
Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
• MsgBox Error
Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
• CELL FORMAT - IF CONDITION
My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
• Show numbers nearly the same
Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...