Hi,
Use the MIN function.
=MIN(range)
Bye,
Jay
Need to fin the minimum value in arow of numbers
This does not work because it is in a row. It does not work in my case anyhow
=MIN(A1:F1)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
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
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.
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
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
Works great thanks for the help
Like this thread? Share it with others