Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Plus a cell reference
Hi, Im trying to add a formula that adds +1 to a cell reference number. example a 1=c12 original 2=c12 3=c12 4=c12 5=a1+1 cell ref which would be c13 6=a2+1 cell ref which would be c13 I have tried drag and drop and it does not follow sequence thanks -- Brento ------------------------------------------------------------------------ Brento's Profile: http://www.excelforum.com/member.php...o&userid=25213 View this thread: http://www.excelforum.com/showthread...hreadid=573466 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Plus a cell reference
Put this in cell A1 and then fill down with it.
=IF(ROW(A1)4,OFFSET(C$12,INT(ROW(A1)/4),0),OFFSET(C$12,0,0)) "Brento" wrote: Hi, Im trying to add a formula that adds +1 to a cell reference number. example a 1=c12 original 2=c12 3=c12 4=c12 5=a1+1 cell ref which would be c13 6=a2+1 cell ref which would be c13 I have tried drag and drop and it does not follow sequence thanks -- Brento ------------------------------------------------------------------------ Brento's Profile: http://www.excelforum.com/member.php...o&userid=25213 View this thread: http://www.excelforum.com/showthread...hreadid=573466 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Plus a cell reference
Disregard what I just posted - after putting it up, I noticed that there is
one group that is just a set of 3 instead of a set of 4, others are OK. Working on correcting that. "Brento" wrote: Hi, Im trying to add a formula that adds +1 to a cell reference number. example a 1=c12 original 2=c12 3=c12 4=c12 5=a1+1 cell ref which would be c13 6=a2+1 cell ref which would be c13 I have tried drag and drop and it does not follow sequence thanks -- Brento ------------------------------------------------------------------------ Brento's Profile: http://www.excelforum.com/member.php...o&userid=25213 View this thread: http://www.excelforum.com/showthread...hreadid=573466 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Plus a cell reference
OK, after a couple of false starts, this will give you groups of 4. Put this
formula in A1 and extend it down: =OFFSET(C$12,INT((ROW(A1)-1)/4),0) "Brento" wrote: Hi, Im trying to add a formula that adds +1 to a cell reference number. example a 1=c12 original 2=c12 3=c12 4=c12 5=a1+1 cell ref which would be c13 6=a2+1 cell ref which would be c13 I have tried drag and drop and it does not follow sequence thanks -- Brento ------------------------------------------------------------------------ Brento's Profile: http://www.excelforum.com/member.php...o&userid=25213 View this thread: http://www.excelforum.com/showthread...hreadid=573466 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
cell reference changes and conditional formatting | Excel Worksheet Functions | |||
How do I anchor a cell reference? | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Cell Reference Math | Excel Worksheet Functions |