Find multiple cells in one spreadsheet

[Johncobb45]

Hi everybody
I'm trying to use the FIND command to search multiple amount of cell
in my large spreadsheet (just one).
How can I enter multiple values (multiple amount of cells to b
searched) in the FIND box?
Is it possible?
It seams to be simple but I don't know what caracters to use.
My spreadsheet has 45 columns and 506 rows. I want to find 6 number
(each one different) at a time in each row.
Thanks in advance for your help.
Joh

 

[Jim Rech]

Excel's Find feature can only search on one text string at a time. You can
use wildcards like "t*day" however.

--
Jim Rech
Excel MVP
|
| Hi everybody
| I'm trying to use the FIND command to search multiple amount of cells
| in my large spreadsheet (just one).
| How can I enter multiple values (multiple amount of cells to be
| searched) in the FIND box?
| Is it possible?
| It seams to be simple but I don't know what caracters to use.
| My spreadsheet has 45 columns and 506 rows. I want to find 6 numbers
| (each one different) at a time in each row.
| Thanks in advance for your help.
| John
|
|
| --
| Johncobb45
| ------------------------------------------------------------------------
| Johncobb45's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=16582
| View this thread: http://www.excelforum.com/showthread.php?threadid=314451
|

 

[Myrna Larson]

Not possible with Find. Perhaps you could devise a formula in a helper column
that, say, returns 1 if the 6 numbers are found, 0, if not, then use
Data/AutoFilter on that column.