| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Searching a text string in a range of cells.
How do i search for something within a text string in a cell which is in a
range of cells. so if a cell contains the names "jim, bob, tom" what formula can i use to just search for "bob" I am currently using a SUMIF function which is only picking up cells that only contain "bob" on its own. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Searching a text string in a range of cells.
=SUMIF(A1:A8,"*bob*",C1:C8)
will sum values in C1:C8 where A1:A8 contain "bob" =COUNTIF(A1:A8,"*bob*") will count occurences of "bob" in A1:A8 BUT only one occurence per cell i.e. "bob,tom,jim,bob" in a cell will count as 1 HTH "heenanmc" wrote: How do i search for something within a text string in a cell which is in a range of cells. so if a cell contains the names "jim, bob, tom" what formula can i use to just search for "bob" I am currently using a SUMIF function which is only picking up cells that only contain "bob" on its own. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Searching a text string in a range of cells.
Thank you very much! That worked perfectly!
"Toppers" wrote: =SUMIF(A1:A8,"*bob*",C1:C8) will sum values in C1:C8 where A1:A8 contain "bob" =COUNTIF(A1:A8,"*bob*") will count occurences of "bob" in A1:A8 BUT only one occurence per cell i.e. "bob,tom,jim,bob" in a cell will count as 1 HTH "heenanmc" wrote: How do i search for something within a text string in a cell which is in a range of cells. so if a cell contains the names "jim, bob, tom" what formula can i use to just search for "bob" I am currently using a SUMIF function which is only picking up cells that only contain "bob" on its own. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need macro to delete all text cells in an Excel range | Excel Worksheet Functions | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Excel - counting cells containing a text string | Excel Worksheet Functions | |||
| Need to convert text string to seperate cells | Excel Worksheet Functions | |||
| Cells and and spaces after a string of text | Excel Worksheet Functions | |||
Hybrid Mode
