Error on Incrementing number again

[Hmuna]

From the picture, i think you can understand my problem....i want to incement the number on "MEMBER" of B Range if the ID is 1 (one), my code "=ROWS(IF(A2>1,A$2:A2,A2))" only give a continous number again. I want to stop the continous number on "1" until it reach another "1".....like i show it on "C Range" "LIKE THIS".....hope u guys help me out again.




thanks in advance

 

[Hmuna]

somebody please help me out........

 

[Ruddles]

Like many corporate systems, mine blocks file-sharing Web sites.

 

[Hmuna]

Thanks for ur reply Mr. Ruddles, my problem is like this:

A B
1 1
2 2
5 3
5 4
3 5
1 1
2 2
4 3
6 4
1 1
5 2
6 3
8 4
1 1

I want to increment the number like in B range if the number in A range is 1 only......hope you get my point, my code display only a continous number.

many thanks for ur reply

 

[Ruddles]

If your data starts in row 1, place 1 in B1 to start the sequence off.

Then place this in B2 and copy down:-

=IF(A2=1,1,B1+1)

 

[Hmuna]

<deleted>

Mr. Ruddles, ur reply is blank......hope u have a solution for my problem.


thanks

 

[Ruddles]

Check now.

(PS. Not "Mr", please - just "Ruddles". )

 

[Hmuna]

many thanks......it's perfectly fine.....phew...i can relax now.....

first i mistype ur name as "Mr.Rubbles"...hehhee.......thanks a ton....have a nice day....i can relax now.

 

[Ruddles]

Ah, perhaps you know my friend Mr Flintstones?