Re: Auto response of one column to another

In cell B1 put: 1 (one)

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

Drag down to cell B100

Regards

Trevor


"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


.

Relevant Pages

  • Auto response of one column to another
    ... I have two columns A and B. Column A is empty and column B is numbered 1 ... 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, ... If then I enter a number or a letter in A10, then B10 should become number one and number down accordingly to the bottom. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Automatically number rows preceded by text
    ... Click on the little black square at bottom right corner of cell A1 ... Drag down ... I apologize if this question has been asked in the past. ...
    (microsoft.public.excel)
  • Re: the drag feature in combining cells wont work
    ... bottom right corner of the cursor, and double-clicking it will copy the ... Pete, thanks for the answer, but I still can't get the drag feature to ... like D2 I get nothing but a blank cell all the way down the column. ... highlight and drag and it will do it for you. ...
    (microsoft.public.excel.worksheet.functions)
  • new to excel
    ... Now Click the little black box in the bottom right of the ... cell and drag the formula down as many lines as you like. ... >find an answer in references that I am using and I am ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Adding and Multiplying Question
    ... on the bottom right of the cell with the above formula ... and drag down to row 260. ... Prev by Date: ...
    (microsoft.public.excel)