finding the minimum value in a row of numbers

drag-driver · Apr 16th, 2002, 10:27 AM

Need to fin the minimum value in arow of numbers

Jay Petrulis · Apr 16th, 2002, 10:33 AM

Hi,

Use the MIN function.

=MIN(range)

Bye,
Jay

drag-driver · Apr 16th, 2002, 10:35 AM

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

Brian from Maui · Apr 16th, 2002, 10:39 AM

Quote:

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 · Apr 16th, 2002, 10:41 AM

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 · Apr 16th, 2002, 10:48 AM

drag-driver · Apr 16th, 2002, 10:49 AM

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 · Apr 16th, 2002, 10:53 AM

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 · Apr 16th, 2002, 10:55 AM

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 · Apr 16th, 2002, 11:13 AM

Works great thanks for the help

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 16th, 2002, 10:27 AM	#1
drag-driver Board Regular Join Date: Feb 2002 Posts: 91	Need to fin the minimum value in arow of numbers

Apr 16th, 2002, 10:33 AM	#2
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	Hi, Use the MIN function. =MIN(range) Bye, Jay

Apr 16th, 2002, 10:35 AM	#3
drag-driver Board Regular Join Date: Feb 2002 Posts: 91	This does not work because it is in a row. It does not work in my case anyhow

Apr 16th, 2002, 10:41 AM	#5
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,030	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

Apr 16th, 2002, 10:48 AM	#6
drag-driver Board Regular Join Date: Feb 2002 Posts: 91

Apr 16th, 2002, 10:49 AM	#7
drag-driver Board Regular Join Date: Feb 2002 Posts: 91	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.

Apr 16th, 2002, 10:53 AM	#8
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,030	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

Apr 16th, 2002, 10:55 AM	#9
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,030	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

Apr 16th, 2002, 11:13 AM	#10
drag-driver Board Regular Join Date: Feb 2002 Posts: 91	Works great thanks for the help