How can I use the CountIf function comparing on TWO TEXT columns instead of one?

Copper Contributor

I am trying to compare two columns with first and last name text to compare and collect a count and I can't figure out how to do that without having to concatenate the columns first.

 

1 Reply

Hi Caryn,

 

If to find the same names within same columns it could be

image.png

 if find them in another two columns when change the ranges in the formula