Sequence based on cell value

[Dani_LobP]

Hi all,

I'm trying to create a way to sequence rows automatically but cant seem to find the smart/short way for it.

So far i am able to build the way to sequence the Primary rows, and the secondary in a different column. My problem comes later when trying to concatenate them or put them together.

=IF(A2="Primary",COUNTIF($A$2:$A2,"Primary"),"")

=IF(A2="Secondary",COUNTIF($A$2:$A2,"Secondary"),"")

-> problem here is that it actually wont always start from 1, it will keep going incremental and wont show a 3.1 but will show as 3.3 ...

Below example of what i am trying to achieve, so that the number in column B is added automatically when i add new row, and call it primary or secondary. Each secondary below the above primary, will be related. and each primary is different as expected.

Column A	Column B
Primary	1
Primary	2
Secondary	2.1
Secondary	2.2
Primary	3
Secondary	3.1
Primary	4

I'm hoping there's an easy way to make this sequence work.

Thanks in advance!

 

[Joe4]

Try this formula (in cell B2 and copied down):

=IF(A2="Primary",INT(MAX(B$1:B1))+1,MAX(B$1:B1)+0.1)

 

[Dani_LobP]

Try this formula (in cell B2 and copied down):

=IF(A2="Primary",INT(MAX(B$1:B1))+1,MAX(B$1:B1)+0.1)

Thanks Joe! works great!

 

[Joe4]

You are welcome.
Glad I was able to help!