Dear all,

I am not at all an excel expert and hope that someone will be able to help me on this. Thanks in advance for that. I am sure it aint a great deal for you guys.
So that is the deal. I have a two column excel sheet with, each raw containing a Combo of a true and false argument. The possible combinations in my case are "only" true&false, false&false and false&true.F
For example:

Colum1 Colum2 Colum3
True False
False False
False False
False False
False False
False True
False False
False False
False False
False False
False False
True False
False False
False False

Now I would like to have a number assigned to each combination in the third column. Lets say nr. 1 to the True&False Combo. The crutial Point is now that I want nr. 1 to be assigned as well to the raws to come after a True&False Combo is detected, until there is a False&True Combo given. The later situation would leads to the nr. 2 being assigned next to this Combo (in the third column). So again Nr. 2 would be assigned to all the following raws, as Long as there is a True&False Combo identified again, what leads to Nr. 1 being assigned to column 3 again and so on.
So for the example above this would mean the following outcome:

Colum1 Colum2 Colum3
True False 1
False False 1
False False 1
False False 1
False False 1
False True 2
False False 2
False False 2
False False 2
False False 2
False False 2
True False 1
False False 1
False False 1


I hope I was clear enough and this can be constructed somehow. Otherwise I have a huge Problem

Greetings

Alf