| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
DCOUNTA & wildcards
I need to do a DCOUNTA on a field looking for value 1*
How do I do this when 1* is a wildcard ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DCOUNTA & wildcards
if you want use * as a character use ~ infront of *
eg: 1~* please do rate "Paul Dennis" wrote: I need to do a DCOUNTA on a field looking for value 1* How do I do this when 1* is a wildcard ? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DCOUNTA & wildcards
thanks for this, however this will find 1*xxxx, how do you check for a space
after the *. "Muhammed Rafeek M" wrote: if you want use * as a character use ~ infront of * eg: 1~* please do rate "Paul Dennis" wrote: I need to do a DCOUNTA on a field looking for value 1* How do I do this when 1* is a wildcard ? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DCOUNTA & wildcards
Use this as criteria
="=1~*" will only find 1* -- Regards, Peo Sjoblom "Paul Dennis" wrote in message ... thanks for this, however this will find 1*xxxx, how do you check for a space after the *. "Muhammed Rafeek M" wrote: if you want use * as a character use ~ infront of * eg: 1~* please do rate "Paul Dennis" wrote: I need to do a DCOUNTA on a field looking for value 1* How do I do this when 1* is a wildcard ? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DCOUNTA & wildcards
How would this work to exclude it. I have tried <"=1~*" but it doesn't seem
to work. "Peo Sjoblom" wrote: Use this as criteria ="=1~*" will only find 1* -- Regards, Peo Sjoblom "Paul Dennis" wrote in message ... thanks for this, however this will find 1*xxxx, how do you check for a space after the *. "Muhammed Rafeek M" wrote: if you want use * as a character use ~ infront of * eg: 1~* please do rate "Paul Dennis" wrote: I need to do a DCOUNTA on a field looking for value 1* How do I do this when 1* is a wildcard ? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DCOUNTA & wildcards
Try
="<1~*" -- Regards, Peo Sjoblom "Paul Dennis" wrote in message ... How would this work to exclude it. I have tried <"=1~*" but it doesn't seem to work. "Peo Sjoblom" wrote: Use this as criteria ="=1~*" will only find 1* -- Regards, Peo Sjoblom "Paul Dennis" wrote in message ... thanks for this, however this will find 1*xxxx, how do you check for a space after the *. "Muhammed Rafeek M" wrote: if you want use * as a character use ~ infront of * eg: 1~* please do rate "Paul Dennis" wrote: I need to do a DCOUNTA on a field looking for value 1* How do I do this when 1* is a wildcard ? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DCOUNTA & wildcards
didn't work - sorry
"Peo Sjoblom" wrote: Try ="<1~*" -- Regards, Peo Sjoblom "Paul Dennis" wrote in message ... How would this work to exclude it. I have tried <"=1~*" but it doesn't seem to work. "Peo Sjoblom" wrote: Use this as criteria ="=1~*" will only find 1* -- Regards, Peo Sjoblom "Paul Dennis" wrote in message ... thanks for this, however this will find 1*xxxx, how do you check for a space after the *. "Muhammed Rafeek M" wrote: if you want use * as a character use ~ infront of * eg: 1~* please do rate "Paul Dennis" wrote: I need to do a DCOUNTA on a field looking for value 1* How do I do this when 1* is a wildcard ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dcounta & dates | Excel Discussion (Misc queries) | |||
| DCOUNTA Complex Criteria Question | Excel Worksheet Functions | |||
| Criteria for DCOUNTA for date values | Excel Discussion (Misc queries) | |||
| Specify DCOUNTA Criteria in the Formula | Excel Discussion (Misc queries) | |||
| Sum Multiple Criteria or DcountA | Excel Worksheet Functions | |||
Linear Mode
