Snake Sequencing

[sheathington]

I have an assignment of data that has been ranked 1 through however many records there are. I want to assign a snaking sequence of A/B and then B/A in order of rank, so it would look something like this:

Rank	A/B
1	A
2	B
3	B
4	A
5	A
6	B
7	B
8	A
9	A
10	B

[CoG]

Is it guaranteed that A and B are equally distributed in the table? or are you adding the A's and B's to the data?

[gawa · Accepted solution]

@sheathington 

Please find the attached WF to do that. Attached WF accepts any length of character not only A/B but also A/B/C/D....whatever.

[Yoshiro_Fujimori]

Hi @sheathington 

Does this formula work for you?

A/B = IF Mod([Rank], 4) / 4 < 0.5 THEN "A" ELSE "B" ENDIF

[sheathington]

Thank you gawa! Your solution worked perfectly.