Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match function in a two input table
I had set up a two input table, using =table function. It seem like the Match
function can not work with it. My table is: Year £14,185.60 1 2 3 4 5 Machine A 9203.00 14185.60 10128.52 7231.76 5163.48 3686.72 Machine B 9611.00 13888.00 9999.36 7199.54 5183.67 3732.24 Machine C 9050.00 14284.80 10170.78 7241.59 5156.01 3671.08 The number 14.185.60 contains the formula =DB The first column is the residual of all the machines. I need to find the max of depreciation of each year then see which machine loses the most value in each year. I already calculated the max for each year but i can not use match to see which machine is..Is there any other way? Or why i can not do it?? Thx a lot |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match function | Excel Worksheet Functions | |||
Trying to match a text string to a data table, any suggestions? | Excel Worksheet Functions | |||
Match function...random search? | Excel Worksheet Functions | |||
ADDRESS function - dynamic input cell | Excel Discussion (Misc queries) | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |