Sir Babydum GBE
08-07-2006, 06:18 AM
Hi,
I want to count cells within a range that contain, say, "QWERTY" anywhere within the cell string.
So if A1 contains "ASDQWERTY", A2 contains "PIYTREWQ" and A3 contains "SQWERTYMM", the count formula will return a 2 on the range A1:A3
Is this possible?
Thanks in advance.
BD
I want to count cells within a range that contain, say, "QWERTY" anywhere within the cell string.
So if A1 contains "ASDQWERTY", A2 contains "PIYTREWQ" and A3 contains "SQWERTYMM", the count formula will return a 2 on the range A1:A3
Is this possible?
Thanks in advance.
BD