Find lowest number in a row in a range of columns

[jaxs2009]

Running Excel 2016, in 2011 a good gentleman helped me with a formula here in Mr Excel in which I have lost, here is what I am needing to do again.

In cell A11, I need a formula that will find the lowest number in a range of columns lets say G11:P11, trick is if all cells in that row between the column range G11:P11 is formatted to accounting and reflecting no entry as I enter a number in each of the cells in that row between the column range I only want cell A11 to reflect the lowest entered number entered. If a cell has no entry then the formula needs ignore no entry cell(s) and find the lowest number.

Thank you to anyone who can help me, Jaxs2009

 

[jaxs2009]

Barry formula =MIN(IF(E558:S558<>0,E558:S558)) does not help me.

Cell A11 is reflecting nothing/zero when there is no number(s) entered in any of the cells with in the column range G11:P11

A number (100) gets entered into cell G11, cell A11 records it, remaining cell still have no entries.
Then another number (75) gets entered into H11, then cell A11 should refelct H11/75, remaining cells still have no entries.
Another number (65) gets entered into cell N11, then cell A11 should reflect N11/65.

and so on until your done with all the entries needed. A11 should always find the lowest number ignoring blank/no entry cells, if all are blank then A11 reflect nothing/zero

Does that make sense from a so/so amateur excel user.

 

[Jonmo1]

Looks like the only difference now is that you want to return nothing/zero if all the cells are blank.
Well, min will indeed return 0 if all the cells are empty.
So a plain simple MIN will work just fine
=MIN(G11:P11)

If you want it to ignore 0s in G11:P11, then the array version from the other thread
=MIN(IF(G11:P11<>0,G11:P11))
Entered as an array with CTRL + SHIFT + ENTER

 

[jaxs2009]

Barry formula doesn't help me.

You will have to forgive me as I may not be good enough to explain what I am trying to do, so please be patient with me.

Cell A11 with a formula is blank/reflecting zero.
All cells G11:P11 are blank/reflecting zero.
Enter a number (100) in cell G11, cell A11 is now reflecting the number entered in G11, remaining cells are still blank.
Then a number (75) is entered in cell K11, cell A11 should now reflect the number entered in K11 as its smaller number found in cell G11, remaining cell are still blank.
Continue and enter a number (65) in cell P11, cell A11 should reflect the number entered in P11. remaining cells are still blank.

Cell A11 ignores blank/non entry cells to find the lowest number in the column range.

Does this help what I am trying to explain/do.

 

[crazydragon84]

My mistake. =MINIFS(G11:P11,G11:P11,"<>")

Did you try this? Alternatively try "<>0"

 

[MARK858]

So what exactly is the answer you don't want with the 3 formula below?

Excel 2010
	A	B	G	H	I	J	K	L	M	N	O	P
11	3		3			6	9	7	5	9	7	0
12	5		8			6	9	7	5	9	7	0
13	0
Sheet1

Cell Formulas
Range	Formula
A11	{=MIN(IF(G11:P11<>0,G11:P11))}
A12	{=MIN(IF(G12:P12<>0,G12:P12))}
A13	{=MIN(IF(G13:P13<>0,G13:P13))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Jonmo1]

Does this help what I am trying to explain/do.

Not really, it's pretty much the same as your last explanation in post #11

What you are describing is exactly what a plain old MIN function does.
It ignores blanks
=MIN(G11:P11)
This will do EXACTLY what you just described.

Now the other thread Barry pointed out, you had the problem that your blanks were not really blank. They were actually zeros.
And the min was considering that the lowest number, because zero actually is a real number.
If this is the case, then you need the array formula to make it ignore those zero values in G11:P11
=MIN(IF(G11:P11<>0,G11:P11))
This will also do exactly what you just described, in addition to ignoring 0 in G11:P11.

 

[jaxs2009]

I hit CTRL + SHIFT + ENTER on cell A11 nothing happens, when I type in the formula in cell A11 =MIN(IF(G11:P11<>0,G11:P11)) it still doesn't work so I believe I am missing something because you are so so much better than me.

 

[Jonmo1]

Are you trying to say that if all cells in G11:P11 are blank, then you DO NOT want to see 0 in A1 ?

What DO you want to see instead? A Blank?

Try
=IF(COUNT(G11:P11),MIN(G11:P11),"")

 

[Jonmo1]

I hit CTRL + SHIFT + ENTER on cell A11 nothing happens, when I type in the formula in cell A11 =MIN(IF(G11:P11<>0,G11:P11)) it still doesn't work

I think our problem here is that we don't understand what "it doesn't work" means.

Are you getting an error? What error?
Do you get the wrong value? What value DID you get? What value did you want instead? And Why?

 

[jaxs2009]

If all cells between G11:P11 are blank cell A11 should reflect blank/zero as you start to enter numbers, a number (75) in let say G11, cell A11 should now reflect cell G11 still ignoring all other blank cells.
Now we enter another number (65) lets say cell N11, cell A11 should now reflect cell N11, still ignoring all other blank cells.

And so on, does this help