Jason Morris
New Member
Hey everyone,
I am trying to count the unique number of times a specific string of text ("CCO" appears within cells in either of two columns. However, it may appear in both columns, and I would not want that to count twice.
Example:
Column A Column G Desired Count
CCO CCO 1
(blank) (blank) 0
(blank) CCO 1
CCO (blank) 1
I was able to get the count from Column 2 by using =IF(ISTEXT('G&A'!G:G),COUNTIF('G&A'!G:G,"*CCO*"),0)
But I cannot seem to get Row 4 to count as 1, I tried using =IF(ISBLANK('G&A'!G:G),COUNTIF('G&A'!A:A,"*CCO*"),) but that is not working.
Any help would be greatly appreciated!!
Thanks
I am trying to count the unique number of times a specific string of text ("CCO" appears within cells in either of two columns. However, it may appear in both columns, and I would not want that to count twice.
Example:
Column A Column G Desired Count
CCO CCO 1
(blank) (blank) 0
(blank) CCO 1
CCO (blank) 1
I was able to get the count from Column 2 by using =IF(ISTEXT('G&A'!G:G),COUNTIF('G&A'!G:G,"*CCO*"),0)
But I cannot seem to get Row 4 to count as 1, I tried using =IF(ISBLANK('G&A'!G:G),COUNTIF('G&A'!A:A,"*CCO*"),) but that is not working.
Any help would be greatly appreciated!!
Thanks