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!

 

[steve the fish]

Yes excel has a function MIN.

 

[joeloveszoe]

SUPER!! that was super easy -thanks sooo much steve the fish =)

 

[63falcondude]

Just FYI: If you wanted to return the header of the smallest value, you can use this formula:

G2 =INDEX(B$1:F$1,MATCH(MIN(B2:F2),B2:F2,0))

This assumes that your data is in A1:F5

 

[joeloveszoe]

well that's a pretty awesome add on feature! very much appreciated!!!! thanks 63falcondude!!!!

 

[joeloveszoe]

hi again!
following up to my original question
is there a way to exclude zeros? i don't want 0 to come up as the lowest number.
thanks again in advance for the help =)

[TABLE="class: cms_table_t1"]
<tbody>[TR]
[/TR]
[TR]
[TD="class: cms_table_td1"]ku[/TD]
[TD="class: cms_table_td1"]price1[/TD]
[TD="class: cms_table_td1"]price2[/TD]
[TD="class: cms_table_td1"]price3[/TD]
[TD="class: cms_table_td1"]price4[/TD]
[TD="class: cms_table_td1"]price5[/TD]
[TD="class: cms_table_td1"]lowest price[/TD]
[/TR]
[TR]
[TD="class: cms_table_td1"]abc1234[/TD]
[TD="class: cms_table_td1"]12.77[/TD]
[TD="class: cms_table_td1"]8.12[/TD]
[TD="class: cms_table_td1"]0.00[/TD]
[TD="class: cms_table_td1"]4.44[/TD]
[TD="class: cms_table_td1"]9.99[/TD]
[TD="class: cms_table_td1"][/TD]
[/TR]
[TR]
[TD="class: cms_table_td1"]brt2345[/TD]
[TD="class: cms_table_td1"]0.00[/TD]
[TD="class: cms_table_td1"]8.55[/TD]
[TD="class: cms_table_td1"]0.00[/TD]
[TD="class: cms_table_td1"][/TD]
[TD="class: cms_table_td1"]8.77[/TD]
[TD="class: cms_table_td1"][/TD]
[/TR]
[TR]
[TD="class: cms_table_td1"]ccc5673[/TD]
[TD="class: cms_table_td1"]3.55[/TD]
[TD="class: cms_table_td1"]0.00[/TD]
[TD="class: cms_table_td1"]5.75[/TD]
[TD="class: cms_table_td1"]7.99[/TD]
[TD="class: cms_table_td1"]6.35[/TD]
[TD="class: cms_table_td1"][/TD]
[/TR]
[TR]
[TD="class: cms_table_td1"]ppw44444[/TD]
[TD="class: cms_table_td1"]9.99[/TD]
[TD="class: cms_table_td1"]15.77[/TD]
[TD="class: cms_table_td1"]0.00[/TD]
[TD="class: cms_table_td1"]0.00[/TD]
[TD="class: cms_table_td1"]12.88

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

 

[Jonmo1]

Try

=INDEX($B$1:$F$1,MATCH(SMALL(B2:F2,1+COUNTIF(B2:F2,0)),B2:F2,0))

 

[joeloveszoe]

thanks for the help! my data is in k2-ap2
=INDEX($F$1:$K$1,MATCH(SMALL(K2:AP2,1+COUNTIF(K2:AP2,0)),K2:AP2,0))
i have hidden columns with in that range) i am getting a #REF ! erorr
=(
are the hidden columns messing me up or is my formula incorrect?
thanks!!!
joeanna =)

 

[Jonmo1]

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

 

[Special-K99]

Something to consider when using MIN/MAX.
What happens if the value is duplicated in the table?