| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Shift to the right depending on dates
I have about 300 columns of data.
I have a table with one column with data that needs to be placed somewhere in those 300 columns depending on the starting date. What formula should I place in the cells of those 300 columns to tell it to begin placing values starting on that specific date? Example: Starting date: June 08 F G H I J .... May 08 June 08 July 08 Aug08 Sept 08 ...... 300 columns B 1. 35 2. 55 3. 57 6. 78 ...... 75. 155 Thanks for your help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Shift to the right depending on dates
Thanks guys, I found the solution after posting.
"JMJ" wrote: I have about 300 columns of data. I have a table with one column with data that needs to be placed somewhere in those 300 columns depending on the starting date. What formula should I place in the cells of those 300 columns to tell it to begin placing values starting on that specific date? Example: Starting date: June 08 F G H I J .... May 08 June 08 July 08 Aug08 Sept 08 ...... 300 columns B 1. 35 2. 55 3. 57 6. 78 ..... 75. 155 Thanks for your help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum a value depending on the value of a cell?? | Excel Worksheet Functions | |||
| Return a value, depending on particular day Q | Excel Worksheet Functions | |||
| Add a row depending on cell value | Excel Worksheet Functions | |||
| How do I add totals from a range of dates depending on the month? | Excel Worksheet Functions | |||
| How to delete a set of rows depending on Value | Excel Discussion (Misc queries) | |||
Linear Mode
