Extracting Account number

[Tid14]

Hi, In my workflow

 i want to use a multi row and exclude the rows starting with END OF and only consider the other rows so that i can then extract the number from.those rows .

Any help on the formula to be used in multi row

[atcodedog05]

Hi @Tid14 

You can use a filter tool like below to filter of rows that start with "End Of"

Hope this helps : )

[drew9]

Hi @Tid14 ,

Multi row formula will be unnecessary. Just use a filter with the parameter LEFT([Field], 6) != 'End of'

Hope this helps!