| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dragging Series?
look at cells A3 A4 and A5, I would like to drag and continuing the
serie...jumping two cells while dragging. or like cells D3, E3 and F3 (esentially the same) A B C D E F 1 2 1 8 2 6 8 2 3 3 (A1+B1) 3 10 14 4 10 (C1+D1) (A1+B1) (C1+D1) (E1+F1) 5 14 (E1+F1) 6 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dragging Series?
=sum(offset($A$1,0,2*row()-6,1,2))
"Guidu" wrote: look at cells A3 A4 and A5, I would like to drag and continuing the serie...jumping two cells while dragging. or like cells D3, E3 and F3 (esentially the same) A B C D E F 1 2 1 8 2 6 8 2 3 3 (A1+B1) 3 10 14 4 10 (C1+D1) (A1+B1) (C1+D1) (E1+F1) 5 14 (E1+F1) 6 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dragging Series?
On Oct 4, 7:11*am, Guidu wrote:
look at cells A3 A4 and A5, I would like to drag and continuing the serie...jumping two cells while dragging. or like cells D3, E3 and F3 (esentially the same) * * * * A * * * B * * * C * * * D * * * E * * * F 1 * * * 2 * * * 1 * * * 8 * * * 2 * * * 6 * * * 8 2 * * * * * * * * * * * * * * * * * * * * * * * 3 * * * 3 * * * (A1+B1) * * * * 3 * * * 10 * * *14 4 * * * 10 * * *(C1+D1) * * * * (A1+B1) (C1+D1) (E1+F1) 5 * * * 14 * * *(E1+F1) * * * * * * * * * * * * 6 * * * * * * * * * * * * * * * * * * * * * * * Try... =SUM(OFFSET($A$1:$B$1,0,ROWS($1:1)*2-2)) Ken Johnson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dragging Series?
Thank you very much
"bpeltzer" wrote: =sum(offset($A$1,0,2*row()-6,1,2)) "Guidu" wrote: look at cells A3 A4 and A5, I would like to drag and continuing the serie...jumping two cells while dragging. or like cells D3, E3 and F3 (esentially the same) A B C D E F 1 2 1 8 2 6 8 2 3 3 (A1+B1) 3 10 14 4 10 (C1+D1) (A1+B1) (C1+D1) (E1+F1) 5 14 (E1+F1) 6 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill Series Dates: not letting me change the series from year to m | Excel Discussion (Misc queries) | |||
| how to plot column chart with one series against multiple series. | Charts and Charting in Excel | |||
| 2nd Axes - primary series data of only 1 series disappears! | Charts and Charting in Excel | |||
| chart data series -- plot a table as a single series | Charts and Charting in Excel | |||
| series graph -- one series being added to another series | Charts and Charting in Excel | |||
Linear Mode
