| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count the number of times a specific word appears in a column
I have a workbook that has several sheets. On the last sheet, I am trying to
total the number of times a code appears in a certain column on a particular sheet. There are some instances where there are multiple codes within a cell. Any help would be greatly appreciated. BAR |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count the number of times a specific word appears in a column
Hi,
One way ... =COUNTIF($B$1:$B$10,"=*Code2*") or putting code in F1 =COUNTIF($B$1:$B$10,"=*" & F1 & "*") Assumes no duplicates in a given cell. HTH "BAR" wrote: I have a workbook that has several sheets. On the last sheet, I am trying to total the number of times a code appears in a certain column on a particular sheet. There are some instances where there are multiple codes within a cell. Any help would be greatly appreciated. BAR |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Count Number of Times Something appears | Excel Worksheet Functions | |||
| Count number of occurences in 1 column only if something in anothe | Excel Worksheet Functions | |||
| Whats the function to count the total times a word is displayed | Excel Discussion (Misc queries) | |||
| How do I count how many times x appears in a column? | Excel Worksheet Functions | |||
Hybrid Mode
