Auto response of one column to another

  • Thread starter Thread starter Colin Hayes
  • Start date Start date
C

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
 
In cell B1 put: 1 (one)

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

Drag down to cell B100

Regards

Trevor
 
Trevor Shuttleworth said:
In cell B1 put: 1 (one)

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

Drag down to cell B100

Regards

Trevor
Click to expand...

Trevor

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

Best wishes

Colin
 
You're welcome. Thanks for the feedback


Colin Hayes said:
Trevor

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

Best wishes

Colin
Click to expand...
 
Back
Top