finding the minimum value in a row of numbers

[drag-driver]

Need to fin the minimum value in arow of numbers

[Jay Petrulis]

Hi,

Use the MIN function.

=MIN(range)

Bye,
Jay

[drag-driver]

This does not work because it is in a row. It does not work in my case anyhow

[Brian from Maui]

On 2002-04-16 09:35, drag-driver wrote:
This does not work because it is in a row. It does not work in my case anyhow

=MIN(A1:F1)

[Asala42]

Hiya,

Is your data simply numeric and stored in a single row (say A1:Z1 for example)? If that is true, =MIN(A1:Z1) should output the minimum value in that range. Is your data not completely numeric but has some order type (blah1,blah2,blahh3 for example)?

feel free to kick out a sample data set,
Adam

[drag-driver]

[drag-driver]

Its not recognising my numbers properly because they were numbers which i cocatenated. Even changing the format to number wont work it kepts returning the value 0 as the minvalue.

[Asala42]

Hey again,

You may want to tweak your concatenation formula a little. Instead of =A5&B5 (simplified example) use =(A5&B5)+0 -> this will autoformat the cell as a number.

You could also do the: Copy a 0, highlight range, editpaste specialadd to convert to a number - then MIN will work.

Adam

[Asala42]

Oh, you could also use an array formula I suppose if you need the concatenated version (say for formatting purposes):

={MIN(A1:Z1+0)}

hit Ctrl+Shift+Enter to get the brackets

Adam

[drag-driver]

Works great thanks for the help