Function for Least Cost.
 

I have an excel spreadsheet that has 5 or so Workbooks in it. On each of
these workbooks I have a company name and a price for a product.

I would like to write a function on a Master page to compair each price on
each workbook and then on the master page display the company name of the
company that had the lowest price.

thanks

Bryan,

Look up Excels MIN function in the online help. An example of the formula
to find the minimum values cell A1 of Sheet1, Sheet2, and Sheet3 would be:

=MIN(A1,Sheet2!A1,Sheet3!A1)

----
Regards,
John Mansfield
http://www.pdbook.com

"Bryan" wrote:

I have an excel spreadsheet that has 5 or so Workbooks in it. On each of
these workbooks I have a company name and a price for a product.

I would like to write a function on a Master page to compair each price on
each workbook and then on the master page display the company name of the
company that had the lowest price.

thanks

Hi John thanks for the reply. I did the Min function that you suggested and
that works to a certain degree. I would actually like to return the company
Name rather then the lowest price. Is that possible with out having to write
a VB script? I assume that the built in fuctions in excel are just mini VB
macro's right?

"John Mansfield" wrote:

Bryan,

Look up Excels MIN function in the online help. An example of the formula
to find the minimum values cell A1 of Sheet1, Sheet2, and Sheet3 would be:

=MIN(A1,Sheet2!A1,Sheet3!A1)

----
Regards,
John Mansfield
http://www.pdbook.com

"Bryan" wrote:

I have an excel spreadsheet that has 5 or so Workbooks in it. On each of
these workbooks I have a company name and a price for a product.

I would like to write a function on a Master page to compair each price on
each workbook and then on the master page display the company name of the
company that had the lowest price.

thanks

You would need VBA since Excel is not very good when it comes to 3D,
but there are already a program that can be downloaded from here

http://longre.free.fr/english/


descriptions here

http://www.rhdatasolutions.com/morefunc/

there is a function called THREED that will take the values from different
sheets and and make them available in an
array that can be used by excel's built in functions, assume you have
installed it and that the company name is in
B1 and the value in A1, then you can use

=INDEX(THREED(Sheet1:Sheet5!B1),MATCH(MIN(THREED(S heet1:Sheet5!A1)),THREED(S
heet1:Sheet5!A1),0))


--

Regards,

Peo Sjoblom

"Bryan" wrote in message
...
Hi John thanks for the reply. I did the Min function that you suggested
and
that works to a certain degree. I would actually like to return the
company
Name rather then the lowest price. Is that possible with out having to
write
a VB script? I assume that the built in fuctions in excel are just mini
VB
macro's right?

"John Mansfield" wrote:

Bryan,

Look up Excels MIN function in the online help. An example of the
formula
to find the minimum values cell A1 of Sheet1, Sheet2, and Sheet3 would
be:

=MIN(A1,Sheet2!A1,Sheet3!A1)

----
Regards,
John Mansfield
http://www.pdbook.com

"Bryan" wrote:

I have an excel spreadsheet that has 5 or so Workbooks in it. On each
of
these workbooks I have a company name and a price for a product.

I would like to write a function on a Master page to compair each
price on
each workbook and then on the master page display the company name of
the
company that had the lowest price.

thanks