Find Lowest Value In Single Row

[jaxs2009]

I am using excel 2010,

In a cell C558 I need to find and reflect the lowest value in cells E558, G558, I558, K558, M558, O558, Q558 & S558.

I have tried a V-LOOKUP but maybe not getting it right?

Can anyone help?

Thank you

 

[Domenic]

Try...

=MIN(E558,G558,I558,K558,M558,O558,Q558,S558)

 

[Jonmo1]

Try the MIN function...

=MIN(E558,G558,I558,etc...)


Also, what is in the intermediate cells (F558, H558, J58, etc)?
Numbers?
If those cells are NOT numeric, then you can just do
=MIN(E558:S558)

Hope that helps.

 

[jaxs2009]

There are no numeric number in cells between these cells, however after trying =MIN(E558:S558) C558 remains zero.

 

[Jonmo1]

There are no numeric number in cells between these cells, however after trying =MIN(E558:S558) C558 remains zero.

That suggests that your numbers are not really numbers,
They are "Numbers Stored As Text"

What does

=ISNUMBER(E558) Return?

 

[jaxs2009]

What I have found is that if anyone of the cells in the selectede range is zero (all cells formatted as accounting, no dollar sign) will refelct a zero value in cells C558.

Need to make this work in a range of cells, some cells may have a number in them and some may be blank.

 

[Jonmo1]

Blanks should be ignored, but a Zero IS in fact a valid number, therefore counted as the minimum number..

Try this array formula entered with CTRL + SHIFT + ENTER

=MIN(IF(E558:S558<>0,E558:S558))

 

[z168]

Jonmo is right. If cells are blank they will be ignored by the MIN function. The accounting format has no relevance

cell G1 has no value, so it picks up $22
cell G2 has ZERO, hence the $ sign, so it picks up $0

 

[jaxs2009]

=ISNUMBER(E558) refelcts "TRUE"

 

[jaxs2009]

The formula =MIN(IF(E558:S558<>0,E558:S558)) CTR+SHFT+ENTER suggestion worked.

Thank you very much everyone who took the time to help me.

Very much appreciated