| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
In excel I wish to copy the value from a cell.
I find a maximum value form an excel spreadsheet column.
Using this value I wish to subtract 0.1 and then find a value in a further column which corresponds with this newly calculated value., then taking this value from an additional column in this row find the vlaue and copy the result into a new cell |
|
#2
|
|||
|
|||
|
If you are in columns A,B and C
try =vlookup(max(A:A)-.1,B:C,2,false) "Ian Winter" wrote: I find a maximum value form an excel spreadsheet column. Using this value I wish to subtract 0.1 and then find a value in a further column which corresponds with this newly calculated value., then taking this value from an additional column in this row find the vlaue and copy the result into a new cell |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hpw do I logic test a cell then copy the row to diff. SS | Excel Worksheet Functions | |||
| How can I copy cell formats in functions? | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| How do I copy Tab into a single cell in Excel? | Excel Discussion (Misc queries) | |||
| Copy Word table into Excel cell by cell | Excel Discussion (Misc queries) | |||
Linear Mode
