automatic row number if data entered in adjacent cell.

[coolmob]

I am entering data sets in an excel sheet. I need serial row numbers to be added automatically when i add data in adjacent cell.

for exmaple row A and B are used for data. I enter date in cell B1 and cell A1 gets populated with Serial no 1. then i add date in cell B6 and A6 gets populated with serial no 2. the gap between two date cells would be random and not fixed. So i need a dynamic formula that can generate the serial number as and when required.

thanks

[ImranBhatti]

Assuming your data starts from B2
In A2 type

=IF(B2<>"",ROW()-1,"")

and drag down

[coolmob]

Assuming your data starts from B2
In A2 type

and drag down

this shows the row number minus one. I want the serial numbers to be sequence. like the first entry would have serial no1 then seven cells down i get serial number 2 after that 3 cells down i get serial no3. the gap between cells would be random.

[mike7952]

Add this to cell A1

Please Login or Register  to view this content.

and this to cell A2 and drag down

Please Login or Register  to view this content.

[coolmob]

Add this to cell A1

Please Login or Register  to view this content.

and this to cell A2 and drag down

Please Login or Register  to view this content.

THANKS A LOT! WORKS LIKE A CHARM

would test and give feedback if i encounter any error

[mike7952]

Thanks for the Rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks