Hi all,
I'm looking to count rows with specific word in a single column with "abb" inbetween any other letters
Example
Column 1
Goodabbok
Badabbnot
Coolabbok
Abbok
I.e. count every word which has "abb" inbetween or at the start , or at the end
Output = 4
Trying to find a solution in forum's but couldn't find it.
Can anyone assist Thanks in advance.
Solved! Go to Solution.
use formula, to create a column by formula. if contains then 1 else 0.
and sum it up later.
*use text to column to split by text to row if more than 1 word.
try to search excel method, it may provide similar solution that can use in alteryx.