How Do U number a list of names, but there are empty rows in betw

P

Paula

I cannot remove empty rows in between names and the number of empty rows
varies from name to name, so how do I number them?
 
R

RagDyeR

Say your names are in Column A.

Insert a *new* Column A, and enter this formula in the *new* A2:

=IF(B2="","",MAX(A$1:A1)+1)

If B1 contains a name, enter 1 in A1,
If not, just copy the formula down as needed.

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I cannot remove empty rows in between names and the number of empty rows
varies from name to name, so how do I number them?
 
Top