[MultiRow Tool] How to detect wrong arrays in columns?

[Joker_Hazard]

Hello Everyone..

I have a doubt about the multirow formula tool. Regarding this image..

I am trying to create a formula that validates if the array contains the same number, three times in a row. If the array contains only one or two rows, then it needs to report which banking account has issues.

I already was able to determine a few parameters for the creation of this array, but I have no clue on how to create this next step.

Maybe using another tool? 

Thanks everyone!

[Emil_Kos]

Hi @Joker_Hazard,

Can you share what is the expected output? 

[Joker_Hazard]

Emil,

To give you the context... 

Lets talk about transactions. All transactions that enter in the system (Example: Book transfer) after being received, it MUST be blocked (represented by "BALANCE BLOCKED") and afterwards it needs to be unblocked (represented by "BALANCE UNBLOCKED").

What I did was to create an array with those three steps Book transfer receivable -> Blocking -> Unblocking.

However, there are a few drawbacks in the system and sometimes a transaction is not blocked therefore, not unblocked. So what I need is a workflow that detects this lack of "blocking and unblocking" and reports in a browse tool for example which transactions did not get blocked/unblocked. 

For this reason that I created this extra column called "Novo Campo" with the arrays

[clmc9601 · Accepted solution]

Hi @Joker_Hazard,

Does this accomplish your goal?

 

Hope it helps!

[Joker_Hazard]

It does, thank you very much!