Excel Array Formulas

[Declare62]

Hello everyone,
This is my first post, I am trying to build a quote templete for work that will take the lowest price quoted and plug that information into one column. I know it can be done because where I worked before we had a excel work sheet that did this. Can anyone point me in the right direction?
Sincerely,
Declare62

 

[Kavy]

You don't give a whole lot of information to what you need, but try
=min()

 

[VoG]

You can get a minimum value using a regular (not array) formula. For example

=MIN(A1:A10)

 

[T. Valko]

Hello everyone,
This is my first post, I am trying to build a quote templete for work that will take the lowest price quoted and plug that information into one column. I know it can be done because where I worked before we had a excel work sheet that did this. Can anyone point me in the right direction?
Sincerely,
Declare62

Let's assume this is your data:

Book1
	C	D	E	F	G
1	65	23	13	40	49
Sheet2

To find the lowest (minimum) value in the range:

=MIN(C1:G1)

Result = 13

 

[Declare62]

Thank you all for such quick replies, can I actually copy part of my spreadsheet so you can actually see what I am trying to achieve?

 

[VoG]

Try using Excel Jeanie to post a shot of your sheet http://www.excel-jeanie-html.de/html/hlp_schnell_en.php

 

[Declare62]

Thanks VoG, I will download excel geni at home later and will post here so you can see what I am trying to do....

 

[Declare62]

Good Morning
I am still in need of some help, I am trying to set up a quote templete that will move both numeric and word text into another section of my spreadsheet to roll it up so to speak.

 

[Rick Rothstein]

So where is the copy of your worksheet for us to see that you said you would post?

 

[Declare62]

I am still trying to figure that out