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

In A1 enter:
1
In A2 enter:
=IF(B2="","",MAX($A$1:A1)+1) and copy down
--
Gary''s Student - gsnu200838

You are a Gent and Thanks a Lot
"Gary''s Student" wrote:

In A1 enter:
1
In A2 enter:
=IF(B2="","",MAX($A$1:A1)+1) and copy down
--
Gary''s Student - gsnu200838