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?
varies from name to name, so how do I number them?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob I
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?
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?
P
Paula
Thank you.
P
Paula
Thanks-it worked!!
R
RagDyeR
You're welcome, and thank you for the feed-back.