Hi

I wonder if someone can help.

I have two columns A and B. Column A is empty and column B is numbered 1
- 100.

What I need to do is this :

When I enter a number or a letter into A , I need B to react by
numbering from 1 onwards in the adjacent sells for each time a new
number or letter is entered.

So for example in cell A1 I have a number of a letter and B1 is number
one , going down to 100.

If then I enter a number or a letter in A10 , then B10 should become
number one and number down accordingly to the bottom.

If I put a number or a letter in sat A40 , then B40 should become number
one and number down consecutively to the bottom.


A B

A 1
2
3
4
5
B 1
2
3
C 1
2
3
4
5
6
7
D 1
etc

If content is removed from A then the cells in B should react
accordingly

Can this be done?

Grateful for any help.

Best Wishes


Colin

In cell B1 put: 1 (one)

In cell B2 put: =IF(A2<"",1,B1+1)

Drag down to cell B100

Regards

Trevor


"Colin Hayes" wrote in message
...
Hi

I wonder if someone can help.

I have two columns A and B. Column A is empty and column B is numbered 1 -
100.

What I need to do is this :

When I enter a number or a letter into A , I need B to react by numbering
from 1 onwards in the adjacent sells for each time a new number or letter
is entered.

So for example in cell A1 I have a number of a letter and B1 is number one
, going down to 100.

If then I enter a number or a letter in A10 , then B10 should become
number one and number down accordingly to the bottom.

If I put a number or a letter in sat A40 , then B40 should become number
one and number down consecutively to the bottom.


A B

A 1
2
3
4
5
B 1
2
3
C 1
2
3
4
5
6
7
D 1
etc

If content is removed from A then the cells in B should react accordingly

Can this be done?

Grateful for any help.

Best Wishes


Colin

In article , Trevor Shuttleworth
writes
In cell B1 put: 1 (one)

In cell B2 put: =IF(A2<"",1,B1+1)

Drag down to cell B100

Regards

Trevor

Trevor

Thanks very much for that. It works perfectly and was exactly what was
required.

Best wishes

Colin


"Colin Hayes" wrote in message
...
Hi

I wonder if someone can help.

I have two columns A and B. Column A is empty and column B is numbered 1 -
100.

What I need to do is this :

When I enter a number or a letter into A , I need B to react by numbering
from 1 onwards in the adjacent sells for each time a new number or letter
is entered.

So for example in cell A1 I have a number of a letter and B1 is number one
, going down to 100.

If then I enter a number or a letter in A10 , then B10 should become
number one and number down accordingly to the bottom.

If I put a number or a letter in sat A40 , then B40 should become number
one and number down consecutively to the bottom.


A B

A 1
2
3
4
5
B 1
2
3
C 1
2
3
4
5
6
7
D 1
etc

If content is removed from A then the cells in B should react accordingly

Can this be done?

Grateful for any help.

Best Wishes


Colin

You're welcome. Thanks for the feedback


"Colin Hayes" wrote in message
...
In article , Trevor Shuttleworth
writes
In cell B1 put: 1 (one)

In cell B2 put: =IF(A2<"",1,B1+1)

Drag down to cell B100

Regards

Trevor

Trevor

Thanks very much for that. It works perfectly and was exactly what was
required.

Best wishes

Colin


"Colin Hayes" wrote in message
...
Hi

I wonder if someone can help.

I have two columns A and B. Column A is empty and column B is numbered
1 -
100.

What I need to do is this :

When I enter a number or a letter into A , I need B to react by
numbering
from 1 onwards in the adjacent sells for each time a new number or
letter
is entered.

So for example in cell A1 I have a number of a letter and B1 is number
one
, going down to 100.

If then I enter a number or a letter in A10 , then B10 should become
number one and number down accordingly to the bottom.

If I put a number or a letter in sat A40 , then B40 should become number
one and number down consecutively to the bottom.


A B

A 1
2
3
4
5
B 1
2
3
C 1
2
3
4
5
6
7
D 1
etc

If content is removed from A then the cells in B should react
accordingly

Can this be done?

Grateful for any help.

Best Wishes


Colin