COMBINE function Find and Or

T

titoto12

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

PCLIVE

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?
 
T

titoto12

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?






- Show quoted text -
Click to expand...

Let say cells contain series of info, and I need to locate all thr
cell with "TON" or "TUNE" using Find, Search function.
 
P

PCLIVE

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
 
Top