| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count 2 (Two) specific words in a cell in a given range
Hi
Im currently having difficulty creating a formula which calculates 2 words in a cell in a given range currently i have a formula which calculates 1 word in a cell =COUNTIF('New Excel Sheet'!A9:Y28,"*WORD1*") Works great when only counting 1 word. The cells look like this ---- words which need counting are "Word1" & "Word2" A B C ------------------------------------------------------- Test : Word1 : Word1 Test : Word2 : Word17 Word1 : : --------------------------------------------------------- Word1 : Word1 : Word100 Word2 : Word2 : Test Word17 : Word20 : Test ------------------------------------------------------------- From this you can see that Word1 & Word2 appeared together in 3 cells Please can anyone help me??? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Count 2 (Two) specific words in a cell in a given range
=COUNTIF('New Excel Sheet'!A9:Y28,"*WORD1*WORD2*")+COUNTIF('New Excel
Sheet'!A9:Y28,"*WORD2*WORD1*") -- Regards, Tom Ogilvy " wrote: Hi Im currently having difficulty creating a formula which calculates 2 words in a cell in a given range currently i have a formula which calculates 1 word in a cell =COUNTIF('New Excel Sheet'!A9:Y28,"*WORD1*") Works great when only counting 1 word. The cells look like this ---- words which need counting are "Word1" & "Word2" A B C ------------------------------------------------------- Test : Word1 : Word1 Test : Word2 : Word17 Word1 : : --------------------------------------------------------- Word1 : Word1 : Word100 Word2 : Word2 : Test Word17 : Word20 : Test ------------------------------------------------------------- From this you can see that Word1 & Word2 appeared together in 3 cells Please can anyone help me??? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Count 2 (Two) specific words in a cell in a given range
Thanks
It works like a treat!!!!!!!!!!!!!! Again thank you very much! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Count 2 (Two) specific words in a cell in a given range
Yes i tried this and it works too!!
Thanks again guys! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count the number of a range of words in a cell | Excel Worksheet Functions | |||
| Count the cell contain a specific numbers in a range | Excel Discussion (Misc queries) | |||
| Count the number of times a cell value is within a specific range | Excel Worksheet Functions | |||
| Is it possible to count specific words in a number of cells? | Excel Discussion (Misc queries) | |||
| count by specific text color in range of cell | Excel Discussion (Misc queries) | |||
Linear Mode
