| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COMBINE function Find and Or
I need to do the fillowing FIND "TON" OR "TUNE" What formula would
do this? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COMBINE function Find and Or
You need to elaborate a little on what you want. Where do you need to find
this? Is it in a column or a cell? What do you want to do once you find it? wrote in message oups.com... I need to do the fillowing FIND "TON" OR "TUNE" What formula would do this? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COMBINE function Find and Or
On May 7, 5:18 pm, "PCLIVE" wrote:
You need to elaborate a little on what you want. Where do you need to find this? Is it in a column or a cell? What do you want to do once you find it? wrote in message oups.com... I need to do the fillowing FIND "TON" OR "TUNE" What formula would do this? Thanks- Hide quoted text - - Show quoted text - Let say cells contain series of info, and I need to locate all thr cell with "TON" or "TUNE" using Find, Search function. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COMBINE function Find and Or
If you want to count the number of cells in column A that contain either
"TON" or "TUNE", then: =COUNTIF(A:A,"TON")+COUNTIF(A:A,"TUNE") The FIND function looks for a text string within a single cell and then returns the number of the starting position of the found string. This is Case-sensitive. The main difference between FIND and SEARCH, is that SEARCH is not Case-sensitive. HTH, Paul wrote in message ups.com... On May 7, 5:18 pm, "PCLIVE" wrote: You need to elaborate a little on what you want. Where do you need to find this? Is it in a column or a cell? What do you want to do once you find it? wrote in message oups.com... I need to do the fillowing FIND "TON" OR "TUNE" What formula would do this? Thanks- Hide quoted text - - Show quoted text - Let say cells contain series of info, and I need to locate all thr cell with "TON" or "TUNE" using Find, Search function. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find date duplicates Col 2 or Col 3 then combine Col 1 text | Excel Worksheet Functions | |||
| how to combine an IF Function with a lookup function to determine | Excel Worksheet Functions | |||
| please help how to combine IF function with Countif function | Excel Worksheet Functions | |||
| Help - combine OR and AND in IF function | Excel Worksheet Functions | |||
| how do i combine IF and OR function | Excel Worksheet Functions | |||
Hybrid Mode
