COMBINE function Find and Or
 

I need to do the fillowing FIND "TON" OR "TUNE" What formula would
do this?
Thanks

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

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.

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.