Hi All, I would like to count the same word in column A and B.... Counting all the repetitive word in result... Thank you. Analysis TypeWinLossCompetitiveWINblindWINOptimizationWINblindWINblindWINblindWINOptimizationWINOptimizationLOSSOptimizationLOSSCompetitiveLOSSCompetitiveLOSSCompetitiveLOSSCompetitiveLOSSCompetitiveLOSS competitiveblindoptimizationWINLOSS64477

How to use something similar to COUNTIF() function

Hi All,

I would like to count the same word in column A and B....

Counting all the repetitive word in result...

Thank you.

<AFTER>

competitive	blind	optimization	WIN	LOSS
6	4	4	7	7

Workflow

Datasets

Preparation

Here is a solution from your input that matches the output!

Here is a solution from your input that matches the output!

This is exactly what I needed!!

Super thanks!

Happy to help!