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>

sku	price1	price2	price3	price4	price5	lowest price
abc1234	12.77	8.12	6.78	4.44	9.99
brt2345	12.43	8.55	12.43	6.79	8.77
ccc5673	3.55	4.78	5.75	7.99	6.35
ppw44444	9.99	15.77	4.14	12.77	12.88

<tbody>
</tbody>

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 =)

ku	price1	price2	price3	price4	price5	lowest price
abc1234	12.77	8.12	0.00	4.44	9.99
brt2345	0.00	8.55	0.00		8.77
ccc5673	3.55	0.00	5.75	7.99	6.35
ppw44444	9.99	15.77	0.00	0.00	12.88

<tbody>
</tbody>

 

[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?