G
Guest
I need to do a DCOUNTA on a field looking for value 1*
How do I do this when 1* is a wildcard ?
How do I do this when 1* is a wildcard ?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
if you want use * as a character use ~ infront of *
eg: 1~*
please do rate
eg: 1~*
please do rate
G
Guest
thanks for this, however this will find 1*xxxx, how do you check for a space
after the *.
after the *.
P
Peo Sjoblom
Use this as criteria
="=1~*"
will only find 1*
="=1~*"
will only find 1*
G
Guest
How would this work to exclude it. I have tried <>"=1~*" but it doesn't seem
to work.
to work.
P
Peo Sjoblom
Try
="<>1~*"
--
Regards,
Peo Sjoblom
="<>1~*"
--
Regards,
Peo Sjoblom
Paul Dennis said:How would this work to exclude it. I have tried <>"=1~*" but it doesn't
seem
to work.
G