| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Searching for text & counting how many times it appears
I import text from various data sources. Is there a function (or if anyone
has a macro) that will allow me to search the worksheet/workbook for a specific text and print the number of times that text appears? The text may not necessarily be in the same location at all times. It could also be combined with other text in a cell e.g. "AJAA" or "AJAA text". As always, your help is greatly appreciated. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Searching for text & counting how many times it appears
=COUNTA([your range],[text you want to count, enclosed in quotation marks])
Example: =COUNTA(A1:A10000,"this is how you count the frequency of a text string") Dave -- Brevity is the soul of wit. "smck" wrote: I import text from various data sources. Is there a function (or if anyone has a macro) that will allow me to search the worksheet/workbook for a specific text and print the number of times that text appears? The text may not necessarily be in the same location at all times. It could also be combined with other text in a cell e.g. "AJAA" or "AJAA text". As always, your help is greatly appreciated. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Searching for text & counting how many times it appears
Think you meant COUNTIF.
Biff "Dave F" wrote in message ... =COUNTA([your range],[text you want to count, enclosed in quotation marks]) Example: =COUNTA(A1:A10000,"this is how you count the frequency of a text string") Dave -- Brevity is the soul of wit. "smck" wrote: I import text from various data sources. Is there a function (or if anyone has a macro) that will allow me to search the worksheet/workbook for a specific text and print the number of times that text appears? The text may not necessarily be in the same location at all times. It could also be combined with other text in a cell e.g. "AJAA" or "AJAA text". As always, your help is greatly appreciated. Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Searching for text & counting how many times it appears
Thank you so much Biff. COUNTIF works better than COUNTA. The only addition I
added to that formula was the asterisk wildcard e.g. "AJAA*" because I wanted Excel to count the occurrence even if there were other words in the cell. When I did not have the wildcard, only the cells with that specific data was counted. "Biff" wrote: Think you meant COUNTIF. Biff "Dave F" wrote in message ... =COUNTA([your range],[text you want to count, enclosed in quotation marks]) Example: =COUNTA(A1:A10000,"this is how you count the frequency of a text string") Dave -- Brevity is the soul of wit. "smck" wrote: I import text from various data sources. Is there a function (or if anyone has a macro) that will allow me to search the worksheet/workbook for a specific text and print the number of times that text appears? The text may not necessarily be in the same location at all times. It could also be combined with other text in a cell e.g. "AJAA" or "AJAA text". As always, your help is greatly appreciated. Thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Searching for text & counting how many times it appears
Thanks for your response Dave however, COUNTIF worked better for my needs.
"Dave F" wrote: =COUNTA([your range],[text you want to count, enclosed in quotation marks]) Example: =COUNTA(A1:A10000,"this is how you count the frequency of a text string") Dave -- Brevity is the soul of wit. "smck" wrote: I import text from various data sources. Is there a function (or if anyone has a macro) that will allow me to search the worksheet/workbook for a specific text and print the number of times that text appears? The text may not necessarily be in the same location at all times. It could also be combined with other text in a cell e.g. "AJAA" or "AJAA text". As always, your help is greatly appreciated. Thanks |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Searching for text & counting how many times it appears
Yeah I meant COUNTIF. Sorry.
-- Brevity is the soul of wit. "smck" wrote: Thanks for your response Dave however, COUNTIF worked better for my needs. "Dave F" wrote: =COUNTA([your range],[text you want to count, enclosed in quotation marks]) Example: =COUNTA(A1:A10000,"this is how you count the frequency of a text string") Dave -- Brevity is the soul of wit. "smck" wrote: I import text from various data sources. Is there a function (or if anyone has a macro) that will allow me to search the worksheet/workbook for a specific text and print the number of times that text appears? The text may not necessarily be in the same location at all times. It could also be combined with other text in a cell e.g. "AJAA" or "AJAA text". As always, your help is greatly appreciated. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting the number of times someone called in sick | Excel Discussion (Misc queries) | |||
| Counting cells with a specified frequency(how many times it appear | Excel Discussion (Misc queries) | |||
| How do I count how many times a code appears in a column? | Excel Worksheet Functions | |||
| Counting the number of times a word appears in a worksheet | Excel Worksheet Functions | |||
| How do I count how many times x appears in a column? | Excel Worksheet Functions | |||
Linear Mode
