Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I have three tables; each table has a product and a price next to
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table - total sell price | Excel Discussion (Misc queries) | |||
Pivot Table - report product that have sales above defined level | Excel Discussion (Misc queries) | |||
Pivot tables | Excel Discussion (Misc queries) | |||
Product Price List with 14k records, filter w/out using AutoFilter | Excel Worksheet Functions | |||
Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions |