Multirow formula based on another unsorted column

[allwynbazil]

Team,

I need to check whether the "Validation Required" column is "Yes". If Yes, I need to repeat the value for the rows that match the Case Number. My formula works only if the Case Number continues. Please help.

Regards,

Alwin

[Felipe_Ribeir0]

Hi @allwynbazil 

One way of doing this

[allwynbazil]

Thanks @Felipe_Ribeir0 . Cant, we achieve this without sorting?

Regards,

Alwin

[Felipe_Ribeir0 · Accepted solution]

@allwynbazil yes, if you delete the record ID tool and the sort tool, it will work. The result will be as expected, but it will not keep the original data order.

Using the multi row formula you would need to sort the data too.

[allwynbazil]

Got it. Thanks @Felipe_Ribeir0