formula to find the lowest number?

[joeloveszoe]

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Helvetica}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font: 11.0px Helvetica}p.p3 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font: 11.0px Helvetica; min-height: 13.0px}table.t1 {border-collapse: collapse}td.td1 {border-style: solid; border-width: 1.0px 1.0px 1.0px 1.0px; border-color: #cbcbcb #cbcbcb #cbcbcb #cbcbcb ; padding: 0.0px 5.0px 0.0px 5.0px}</style>[TABLE="class: t1"]
<tbody>[TR]
[TD="class: td1"]sku
[/TD]
[TD="class: td1"]price1
[/TD]
[TD="class: td1"]price2
[/TD]
[TD="class: td1"]price3
[/TD]
[TD="class: td1"]price4
[/TD]
[TD="class: td1"]price5
[/TD]
[TD="class: td1"]lowest price
[/TD]
[/TR]
[TR]
[TD="class: td1"]abc1234
[/TD]
[TD="class: td1"]12.77
[/TD]
[TD="class: td1"]8.12
[/TD]
[TD="class: td1"]6.78
[/TD]
[TD="class: td1"]4.44
[/TD]
[TD="class: td1"]9.99
[/TD]
[TD="class: td1"]

[/TD]
[/TR]
[TR]
[TD="class: td1"]brt2345
[/TD]
[TD="class: td1"]12.43
[/TD]
[TD="class: td1"]8.55
[/TD]
[TD="class: td1"]12.43
[/TD]
[TD="class: td1"]6.79
[/TD]
[TD="class: td1"]8.77
[/TD]
[TD="class: td1"]

[/TD]
[/TR]
[TR]
[TD="class: td1"]ccc5673
[/TD]
[TD="class: td1"]3.55
[/TD]
[TD="class: td1"]4.78
[/TD]
[TD="class: td1"]5.75
[/TD]
[TD="class: td1"]7.99
[/TD]
[TD="class: td1"]6.35
[/TD]
[TD="class: td1"]

[/TD]
[/TR]
[TR]
[TD="class: td1"]ppw44444
[/TD]
[TD="class: td1"]9.99
[/TD]
[TD="class: td1"]15.77
[/TD]
[TD="class: td1"]4.14
[/TD]
[TD="class: td1"]12.77
[/TD]
[TD="class: td1"]12.88
[/TD]
[TD="class: td1"]

[/TD]
[/TR]
</tbody>[/TABLE]

i have information like this
is there a formal i can put in the lowest price cell to tel me what the lowest price/number is in the row?

thanks in advance for your help!!!
=) have a happy day!

 

[joeloveszoe]

You also need to change $F$1:$K$1 to reflect the headers of the columns K - AP

thanks for writing back - i dont understand what you are saying =(

 

[Jonmo1]

Here's the formula I posted
=INDEX($B$1:$F$1,MATCH(SMALL(B2:F2,1+COUNTIF(B2:F2,0)),B2:F2,0))

You said your data is actually in k2-ap2 so you changed the formula to
=INDEX($F$1:$K$1,MATCH(SMALL(K2:AP2,1+COUNTIF(K2:AP2,0)),K2:AP2,0))

I'm saying you also need to change this to match the same columns
=INDEX($F$1:$K$1,MATCH(SMALL(K2:AP2,1+COUNTIF(K2:AP2,0)),K2:AP2,0))

Probably
=INDEX($K$1:$AP$1,MATCH(SMALL(K2:AP2,1+COUNTIF(K2:AP2,0)),K2:AP2,0))

 

[joeloveszoe]

got it and thank you - one thing though - when i use that formula - it gives me the column name in the field (which is great)
what formula can i use to display the lowest number?
thank you =)

 

[Jonmo1]

That would be

=SMALL(K2:AP2,1+COUNTIF(K2:AP2,0))

 

[joeloveszoe]

thanks - I've adjusted the formula and its mostly working - just not weeding out the zeros ... and sometimes there are zeros in more than one cell
any additional thoughts?
thanks!

 

[Jonmo1]

Works for me
Could be that your zeros are not really zeros. Maybe they are 0.01 or some small decimal value, but you have the cells formatted to show no decimals.

Working example

Excel 2013/2016
	I	J	K	L	M	N	O	P	Q
2	12		77	23	0	88	0	0	12
Sheet1

Cell Formulas
Range	Formula
I2	=SMALL(K2:AP2,1+COUNTIF(K2:AP2,0))

 

[joeloveszoe]

thats perfect!!!! thanks very much!