Conditional Sequence of the Item

[SH_94]

Hi Community,

I would like to ask how to build the formula if i have the input below and desired output as per screenshot below:

Basically the sequence of the flow will be as below:

1. If the month contain item AA, BB and CC, it will be the prioprity by following the month sequence. For examples,For the month of July, the sequence will start with AA, BB and CC under the July, then follow by AA,BB and CC under June and then follow by AA, BB and CC under the May. The sequence always start with AA >>BB>> CC ( and then following by next month sequence)

2. After that, it will follow by the DD with the month sequence, For example, DD under the July, and then follow by DD under June and then follow by DD under May

3. Lastly, it will follow by EE with the month sequence, For example,EE under the July, and then follow by EE under June and then follow by EE under May

[binuacs · Accepted solution]

@SH_94 Interesting use case. One way of doing this

[SH_94]

Hi @binuacs ,

I never think of it can be done it this way... It is really amazing on how to solve the solution.

Many thanks again for the help.