View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
siteguy siteguy is offline
external usenet poster
 
Posts: 1
Default Can I do Excel formula that variably shifts columns right or left

I need to learn how to shift data right or left in columns based upon an
input. For instance, let's say I take 10 orders in January. I have a
constant value that assumes it will take me 4 months to build them. I then
want to show 10 sales in May (4 months after order). If I change the
manufacturing assumption to 3 months, I want the 10 sales to reflect in
April, one column to the left.