AutoNumber/RecordID
 

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

AutoNumber/RecordID
 

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.

--
Regards,
Tom Ogilvy


"Marc" wrote:

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