I have three tables; each table has a product and a price next to
You are talking about doing some programming unless the structures of your
three "tables" are precisely consistent. Lets say, for example, we have a
best case scenario in which you have three worksheets with products A, B, and
C in column "A" with their corrensponding prices in column "B". In another
worksheet, you could head a column "Minimum Price" under which would be the
formula "MIN(Sheet1!B1,Sheet2!B1,Sheet3!B1)" which would simply give you the
lowest of the three values in Sheets 1 through 3. Regardless of how you use
the "MIN" function, it will give you the lowest of the set of numbers
included in the ( ).
--
Y
"Nader" wrote:
I have three tables; each table has a product and a price next to it form
three different manufacturers. i would like to compare between the three
companies to find out who has the cheaper prices for the same produce and I
would like the answer in a new column. In another word I want to compare the
value between three tables (columns) to find out the lesser value and the
maybe to get the output in a new columns.
Is this possible.
|