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

  • Thread starter Thread starter Paula
  • Start date Start date
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?
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
how to remove empty rows? 2
Calculate number of rows and apply formula 4
How to add an empty row after each data set of . 2
Count latest number of continous not-empty cells in a row. 11
Numbering rows and skipping blanks 3
Summary Worksheet. 1
Help on Macro to hide empty rows 4

Back
Top