Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking at previous columns
I've got a pretty long multiple IF statement to work out the most recen date from several columns, and then returns a figure in the column t the left. This works fine, but I want to be able to use it to work ou the previous figure. The previous figure will be 2 columns to the lef of the most recent. In short, All i want to know is...Is there a way of getting excel t find the most recent figure and then jump back two columns -- M3Cob ----------------------------------------------------------------------- M3Cobb's Profile: http://www.excelforum.com/member.php...fo&userid=2498 View this thread: http://www.excelforum.com/showthread.php?threadid=38637 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking at previous columns
hope I have understood. use offset function. offset(0,-2) will go to the
cell in the same row 2 columns to the left. M3Cobb wrote in message ... I've got a pretty long multiple IF statement to work out the most recent date from several columns, and then returns a figure in the column to the left. This works fine, but I want to be able to use it to work out the previous figure. The previous figure will be 2 columns to the left of the most recent. In short, All i want to know is...Is there a way of getting excel to find the most recent figure and then jump back two columns? -- M3Cobb ------------------------------------------------------------------------ M3Cobb's Profile: http://www.excelforum.com/member.php...o&userid=24986 View this thread: http://www.excelforum.com/showthread...hreadid=386377 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking at previous columns
M3Cobb
Don't know exactly what the code should be to jump a cell to te left, but i know it can be done with 'cell offset' Hope this will help you a bit. Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
For John, et al. Re Combining Columns (previous post) | New Users to Excel | |||
scrolling columns behind previous columns | Excel Worksheet Functions | |||
Losing previous highlighted columns when doing multiple column hi. | Excel Worksheet Functions | |||
Hide Cell Content if no data in previous columns | Excel Discussion (Misc queries) | |||
Columns that will grab a value from a previous column, incrimental | Excel Programming |