AutoNumber/RecordID

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What I want to do is in column A to automatically number/count the rows only
if column B is filled in. Any Ideas?


A B
1 Record Id Name
2 1 Marc
3 2 Sally
4 3 Joe
5
 
in A2 put in a 1, in A3 put in a 2. Select A2:A3 and double click the little
square on the lower right corner of the selection highlight to fill down.
 
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

Converting Header Rows to Add'l Detail in Rows 4
A data validation question 1
COUNT for 2 or MORE CONDITIONS 5
Merge data by macro 9
Weighted randbetween text list 3
Counting Criteria Values with For Loop 3
How to add a "running count" to cells with matching data 2
array - how do I do this????? 1

Back
Top