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 |
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 |
All times are GMT +1. The time now is 10:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com