| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time align New Product Launches
Hello. I have 150 weeks of data across my page and many rows containing
products. My cells contain $ sales. The products sales start at different points because they were launched at different times over the 150 weeks. I would like to align every products sales so that their 1st weeks sales all line up under each other and the same for week 2 etc so that I can compare sales for each product launch. Can anyone please help? Thank you. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Time align New Product Launches
An example of what the data looks like and what you want it to look like
worild help. Make sure you clearly show empty cells. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "ManKind" wrote in message ... Hello. I have 150 weeks of data across my page and many rows containing products. My cells contain $ sales. The products sales start at different points because they were launched at different times over the 150 weeks. I would like to align every products sales so that their 1st weeks sales all line up under each other and the same for week 2 etc so that I can compare sales for each product launch. Can anyone please help? Thank you. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Time align New Product Launches
Hello Bob. Where can I send the sample output? Thank you.
"Bob Phillips" wrote: An example of what the data looks like and what you want it to look like worild help. Make sure you clearly show empty cells. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "ManKind" wrote in message ... Hello. I have 150 weeks of data across my page and many rows containing products. My cells contain $ sales. The products sales start at different points because they were launched at different times over the 150 weeks. I would like to align every products sales so that their 1st weeks sales all line up under each other and the same for week 2 etc so that I can compare sales for each product launch. Can anyone please help? Thank you. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Time align New Product Launches
Lay it out in a post here.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "ManKind" wrote in message ... Hello Bob. Where can I send the sample output? Thank you. "Bob Phillips" wrote: An example of what the data looks like and what you want it to look like worild help. Make sure you clearly show empty cells. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "ManKind" wrote in message ... Hello. I have 150 weeks of data across my page and many rows containing products. My cells contain $ sales. The products sales start at different points because they were launched at different times over the 150 weeks. I would like to align every products sales so that their 1st weeks sales all line up under each other and the same for week 2 etc so that I can compare sales for each product launch. Can anyone please help? Thank you. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Time align New Product Launches
Thanks for your offer. I have worked it out. Have a great day.
"Bob Phillips" wrote: Lay it out in a post here. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "ManKind" wrote in message ... Hello Bob. Where can I send the sample output? Thank you. "Bob Phillips" wrote: An example of what the data looks like and what you want it to look like worild help. Make sure you clearly show empty cells. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "ManKind" wrote in message ... Hello. I have 150 weeks of data across my page and many rows containing products. My cells contain $ sales. The products sales start at different points because they were launched at different times over the 150 weeks. I would like to align every products sales so that their 1st weeks sales all line up under each other and the same for week 2 etc so that I can compare sales for each product launch. Can anyone please help? Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel launches AOL too | Excel Discussion (Misc queries) | |||
| Macro launches VB IDE window | Excel Programming | |||
| Left align '$' and right align numbers? | Excel Discussion (Misc queries) | |||
| What is short-Cut forleft align and Right align? | Excel Discussion (Misc queries) | |||
| Excel launches in a separate window | Excel Programming | |||
Linear Mode
