numbering a column

  • Thread starter Thread starter Guest
  • Start date Start date
Hi
not quite sure what you're trying to achieve but the following formula
will put a sequencing number
in column A, if column B is filled:

in A1 enter the following formula
=IF(B1<>"",1,"")

in A2 enter the formula
=IF(B2<>"",MAX($A$1:OFFSET($A2,-1,0))+1,"")
and copy this formula down for as many rows as you like

this formula will add a sequencing number in column a for all rows in
which
column B contains a value
 
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

Week numbers from an entered date 5
Efficient looping 6
Excel Numbering rows by font color, but skipping blanks 1
Six columns randon no.'s no dupes 6
Match columns to rows then loop. 2
Copy columns and paste with blank column between 5
Optional argument as Variant not acting like number 4
Best Practice for Public Variables for Column Headings 2

Back
Top