aUTO nUMBERING

[Udayan]

Help me please.

Is there any way to automatically number in column A only if there is any
data in column B.


SL Item
-----------------------
1 have data
no data
2 have data
3 have data
4 have data
no data
5 have data

 

[Gary''s Student]

In A1 enter:
1
In A2 enter:
=IF(B2="","",MAX($A$1:A1)+1) and copy down

 

[Udayan]

You are a Gent and Thanks a Lot