add 1
 

I havent used excel in a while and am stuck on what i thought was easy
doh any help appreciated

want columns to add 1 even if it is just adding 1 to the corresponding
value in the left column it would be a great help e.g.

Karen 1 2 3 4 5
Frank 6 7 8 9 10

Cheers


--
excelled
------------------------------------------------------------------------
excelled's Profile: http://www.excelforum.com/member.php...o&userid=33076
View this thread: http://www.excelforum.com/showthread...hreadid=528872

add 1
 

If you enter a formula and then fill it across the columns this should
work
if Coluimn A has a name then column B will have a number and column C
will have this formula
=B1+1

copy the formula across the columns and it should work for you


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=528872