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.

--
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