| 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 |
| 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 | |||
Threaded Mode
