Re: Auto response of one column to another

Tech-Archive recommends: Fix windows errors by optimizing your registry

In article <eGXdu#3hHHA.4844@xxxxxxxxxxxxxxxxxxxx>, Trevor Shuttleworth <Trevor@xxxxxxxxxxxxxxxxxx> 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" <Colin@xxxxxxxxxxxxxxxxxx> wrote in message
news:eY8MHSA387LGFwJW@xxxxxxxxxxxxxxxxxxxxx
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




.

Quantcast