Countif based of partial cell contents
You're welcome. Thanks for the feedback!
--
Biff
Microsoft Excel MVP
"Tony S." wrote in message
...
That works great for no spaces. Thanks for the help.
--
Tony S.
"T. Valko" wrote:
Try this:
H1 = BBDC3245 (no spaces)
=COUNTIF(D6:D1006,"*"&H1&"*")
--
Biff
Microsoft Excel MVP
"Tony S." wrote in message
...
II need help modifying a formula.
=COUNTIF($D$6:$D$1006,H1)
This returns the count for the value in H1 fine, but I need to modify
it
so
it will still return the correct number if there are spaces or
characters
before or after the value in H1.
Example:
If H1 contains "BBDC3245---" or a space exists before or after "
BBDC3245
"
,I want to still count all the occurrences of that base number in col
D6to
D1006. I guess I need kind of a wild card search?
--
Tony S.
|