Excel Formula

[SilverJock]

Hi, I am looking for a formula for this.
I want to enter data into the B column (mainly text)and i want the next cell in the A column to enter in a consecutive number right down as far as the B column has data.
This is so that the data in column B is given an automatic reference number.
If possible i would like the numbers to carry on to another sheet within the same workbook.

Any help is greatly apreciated.

Steve

 

[SkipVought]

Hi,

Enter in A1 and copy down...
[tt]
=if(isblank(b1),"",row())
[/tt]


Skip,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}

 

[SkipVought]

BTW, just enter the formula on another sheet, but if you want the numbers to be different, you'll have to modify the formula like...
[tt]
=if(isblank(b1),"",row()+65536)
[/tt]


Skip,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}

 

[SilverJock]

Many thanks, that works great, just what i was after.
Can you recommend any site/book where i can learn more about formulas?

Thanks Again

Steve

 

[SkipVought]

I like John Walkenbach's books

http://www.j-walk.com

Skip,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}