| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula for shifts from times | Excel Discussion (Misc queries) | |||
| In Excel My Columns are going from right to left, how can I fix i. | Excel Discussion (Misc queries) | |||
| Text shifts left in Excel Combo Box when user types in entry | Excel Discussion (Misc queries) | |||
| Summing a variably-sized range | Excel Worksheet Functions | |||
| How do I drag a formula from right to left columns instead of rig. | Excel Discussion (Misc queries) | |||
Threaded Mode
