Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Increment column by column from data row by row
Can I increment a cell reference as I replicate data across a row. in
my example it just retains $B2 for all cell references. e.g A B C D E 1 =A2+$B2 =A2+$B3 =A2+$B4 2 Andy Old 3 Peter Young 4 James Old 5 Mary Old Jonah |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Increment column by column from data row by row
try
=$A2+B2 instead. In article , Jonah wrote: Can I increment a cell reference as I replicate data across a row. in my example it just retains $B2 for all cell references. e.g A B C D E 1 =A2+$B2 =A2+$B3 =A2+$B4 2 Andy Old 3 Peter Young 4 James Old 5 Mary Old Jonah |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Increment column by column from data row by row
No luck there. Any other thoughts
Jonah JE McGimpsey wrote: Try =$A2+B2 instead |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Increment column by column from data row by row
Do you want to increment down row wise while you copy across?
If you want to increment like B2, B3 and so on while copying across you can use =OFFSET($B$2,COLUMN(A:A)-1,) -- Regards, Peo Sjoblom (No private emails please) "Jonah" wrote in message ... No luck there. Any other thoughts Jonah JE McGimpsey wrote: Try =$A2+B2 instead |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Increment column by column from data row by row
I missed that you wanted to increment the row, not the column.
One way: C1: =$A2+INDEX($B:$B,COLUMN()-1) Note however, that given your sample data, you'll only get #VALUE! errors, since the + operator requires two numeric values, not text. Did you mean to concatenate (&) instead? In article , Jonah wrote: No luck there. Any other thoughts |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Increment column by column from data row by row
Superb! And is it possible from another workbook? I would never have found
that in the Help without knowing what I was looking for. Jonah Peo Sjoblom wrote: Do you want to increment down row wise while you copy across? If you want to increment like B2, B3 and so on while copying across you can use =OFFSET($B$2,COLUMN(A:A)-1,) -- Regards, Peo Sjoblom (No private emails please) "Jonah" wrote in message ... No luck there. Any other thoughts Jonah JE McGimpsey wrote: Try =$A2+B2 instead |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Increment column by column from data row by row
CRACKED it. Thanks. Peo.
Jonah wrote And is it possible from another workbook? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional format based on data from another column | Excel Discussion (Misc queries) | |||
displaying data within column | Charts and Charting in Excel | |||
2 Column Data lookup | Excel Discussion (Misc queries) | |||
Combining workbooks with some variable field names | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |