Thread: formula to stay fixed on two columns as you add more columns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
usingexcel usingexcel is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote