One thought ..
Assuming your source data running down in col A
you could use this in say, B1:
=COUNTA(A:A)-COUNTIF(A:A,"*"&"ditto"&"*")
voila? zonk YES below
--
Max
Singapore
---
"justjill111" wrote:
if i have the word 'ditto' scattered among a bunch of names (text), how do i
count every value that's not 'ditto' ? am i trying to combine "COUNTIF"
value with "NOT" criterion...?