Excel Formula to find a Sequence

I am not very good with excel but I am looking for a formula that would calculate the following

A B
3 1 True
4 2 True
3 5 False Transition
6 7 False
5 8 False
6 5 No Sequence Transition
8 9 No Sequence

For each time A is greater than B in a sequence of 2 or more rows it says True. If A is less than B in a sequence of 2 or more rows it turns up False. When a sequence starts, it needs to read False Transition or True Transition. If there is no sequence, meaning A is greater than B in the first row, then A is less than B in the next row and then back to A greater than B in the third row, it turns up NoSequence.

Then I need to calculate the percentage of True, False, No Sequence in the entire sample size.

Sorry if this is confusing.

Thanks in advance

See attached, I hope it's what you need.

Regards,
Antonio

Antonio,

Thanks for the help. The count and percent look good but I cant seem to find the formula that identifies if it is a True, False, True Transition, False Transition, No Sequence or No Sequence Transition. I have thousands of lines of data I am trying to identify the sequences with a label from above (True, False, True Transition, False Transition, No Sequence, No Sequence Transition)

Thanks

The transition rule does not apply to the very first line then?

Correct. The transition is when the sequence is broken and it the first row of the new sequence.

Thanks for the help. I tried to run the code above but Im not sure if my computer is just not powerful enough or the code was wrong. I put it in Visual Basic Editor code section and hit run. The hour glass for a mouse never went away after 1 hour. Any thoughts?

attached file?

YES! Thanks. No I need to figure the percent of Falses, Trues, No Sequence in the total sample. etc