Order repeating series

series.jpg

I have same values in A column (like a value).
In B column I want to make serial sort number for a values. By formula NOT Macro.
First group of a values must be 1 and second group of a value must be 2 and continuing so on.
There is some other data between a value groups. Don't care these other data.

Only a values groups need serial number starting from 1st.

Attached pic. shows the structure of example.

Waiting for reply, thanks in advance.

Regards.

Thanks XOR LX.
Great, works.

Regards.

Originally Posted by XOR LX

Hi,

One way. In B2 and copy down (must be entered as as array formula):

=IF(A2<>"a","",SUM(--(FREQUENCY(IF(A$1:A2<>"a",ROW(A$1:A2)),IF(A$1:A2="a",ROW(A$1:A2)))>0)))

Regards

try this
=IF(A2="","",IF(A1=A2,B1,MAX(B$1:B1)+1))

Originally Posted by Ghozi Alkatiri

try this
=IF(A2="","",IF(A1=A2,B1,MAX(B$1:B1)+1))

Working.
Thanks.