Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
DCOUNTA search in field for value
I have a field which is text and I need to search within it for a value
within my DCOUNTA. Is this possible? How? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
DCOUNTA search in field for value
Yes it certainly is
for example if the strings can look like "Horse meat is good" "You have to go to Canada to have horse meat if you live in the US" "The Congress critters won't allow Americans to eat horse meat" and you want to count "meat" use this ="=*meat*" -- Regards, Peo Sjoblom "Paul Dennis" wrote in message ... I have a field which is text and I need to search within it for a value within my DCOUNTA. Is this possible? How? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dcounta & dates | Excel Discussion (Misc queries) | |||
Creating a Search Field? | Excel Worksheet Functions | |||
Search field? | Excel Discussion (Misc queries) | |||
Find/replace search field defaults | Excel Discussion (Misc queries) | |||
how can I search a field for a particular word | Excel Worksheet Functions |