Auto response of one column to another

[Colin Hayes]

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

 

[Trevor Shuttleworth]

In cell B1 put: 1 (one)

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

Drag down to cell B100

Regards

Trevor

 

[Colin Hayes]

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

 

[Trevor Shuttleworth]

You're welcome. Thanks for the feedback

Trevor

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

Best wishes

Colin