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

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?

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

On a copy of your sheet, try selecting the sheet and then "Sort"

Paula wrote:

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?

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

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!
================================================== ===

"Paula" wrote in message
...
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?

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

Thank you.

"Bob I" wrote:

On a copy of your sheet, try selecting the sheet and then "Sort"

Paula wrote:

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?

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

Thanks-it worked!!

"RagDyeR" wrote:

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!
================================================== ===

"Paula" wrote in message
...
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?

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

You're welcome, and thank you for the feed-back.
--

Regards,

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

"Paula" wrote in message
...
Thanks-it worked!!

"RagDyeR" wrote:

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!
================================================== ===

"Paula" wrote in message
...
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?