Hello!
I am trying to create a new column of data that counts the number of times other columns of data, in the same row, contain a certain word.
In this example, I want to know the number of columns that contain the word "Completed" for each user.
I have been stuck on this for a while so thank you all for the help in advance!
Solved! Go to Solution.
Hey @Clandmann
Have a go with this solution:
If you use the transpose tool, you can then count the number of columns which contain 'completed' per row
Hope that helps,
Ollie
This works like a charm! Thank you for the help.