| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum first five vaules of changing range
I have about 1000 rows of sales data, going back about 2.5 years. I need the
first five months sales for each row, but as they were all launched on different dates, it's proving tricky. I'm sure there has to be an easier way to do this than selecting the values for each row at a time, but just now I can't for the life of me think how to do it! Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| dont show zero vaules in a chart | Charts and Charting in Excel | |||
| If no value in a1 how do I get a2 a3 a4 a5 a6 a7 a8 not to show their vaules | Excel Worksheet Functions | |||
| Truning 0 vaules red | Excel Worksheet Functions | |||
| copy/paste vaules, not formulas | New Users to Excel | |||
| copy/paste vaules, not formulas | New Users to Excel | |||
Threaded Mode
