Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find amount in row.
Hello All:
I would like to know how can I find out the folowing. I have a chart like this: Type Company 1 Company 2 Company 3 Product Plastic 3.69 0.79 0.89 Metal 0.99 2.57 1.99 Wood 1.69 0.89 0.99 If I type in a cell A1 Plastic, then then cell A2 should tell me the highest price found in the row for plastic. I also want to be able to type plastic in A1 and then in B1 wood and in cell A2 should calculate the total highest price for both. Thanks in advance for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find the smallest amount | Excel Discussion (Misc queries) | |||
Find a cummulative amount | Excel Discussion (Misc queries) | |||
find values that add up to certain amount | Excel Discussion (Misc queries) | |||
find same amount in different workbooks | Excel Worksheet Functions | |||
How do I find the amount of hours between 6:00 PM to 12:30 AM? | Excel Worksheet Functions |