formula to find the lowest number?

joeloveszoe

Board Regular
Joined
Apr 24, 2014
Messages
110
Office Version
  1. 365
Platform
  1. MacOS
<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!
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
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))
 
Last edited:
Upvote 0
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 =)
 
Upvote 0
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!
 
Upvote 0
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
IJKLMNOPQ
21277230880012
Sheet1
Cell Formulas
RangeFormula
I2=SMALL(K2:AP2,1+COUNTIF(K2:AP2,0))
 
Upvote 0

Forum statistics

Threads
1,223,099
Messages
6,170,107
Members
452,302
Latest member
TaMere

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top