Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Incrementing cell addresses
I building a worksheet where I have 3 agents, each agent has its own set of
data as follows: 02/28/08 Name - # of payments - Hours Mark 2 8.00 john 3 9.00 jim 4 6.00 02/29 Name - # of payments - Hours Mark 2 8.00 john 3 9.00 jim 4 6.00 I want to use the above data to be linked to cells in the following format: mark 02/28 02/29....etc payments 2 2 Hours 3 3 So, as I am updating each agent daily, the same data is updated in a horizontal fashion (by date). Also, since I have several agents and I want to able to drag my formula thru the whole month, I would need to increment each cell address by not 1 but by 5 (as I have in my example)..Can that be done? -- EddieV |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Incrementing cell reference | Excel Discussion (Misc queries) | |||
Incrementing cell reference in Lookup formula | Excel Worksheet Functions | |||
Dragging & incrementing cell values | Excel Worksheet Functions | |||
incrementing mm/yy based on value in other cell | Excel Worksheet Functions | |||
Incrementing Cell Numbers | Excel Discussion (Misc queries) |