| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to stay fixed on two columns as you add more columns
:) Hello, I have data on column B and C, column E is the output. I will be adding a new column once a week (therefore B becomes C and C ---D) However, i need the output on E to be the result whatever is on B and C...in other words I don't want the formula to 'fix' itself as I add new columns in front of B and C. Thanks! -- usingexcel ------------------------------------------------------------------------ usingexcel's Profile: http://www.excelforum.com/member.php...o&userid=37043 View this thread: http://www.excelforum.com/showthread...hreadid=567702 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| fixed columns | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| How do I get a formula to use data from a fixed location(NOT vicev | Excel Discussion (Misc queries) | |||
| Req Formula to place 1 into next columns | Excel Worksheet Functions | |||
Threaded Mode
