"CJRolls" wrote:
Hello, I need to have excel fill a cell only
if there is a value in the cell
to the right. I.e Column A1 increases by 1
whenever I enter a value in column
B2 and so on down the sheet. Thanks

One guess ..

Assuming B1 contains a label,
put in A1: =IF(COUNTA(B:B)=1,"",COUNTA(B:B)-1)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---