ctrl+F

[pierre]

im using the ctrl+F option....
i am searching within A1 to A4 and i would like for example to search for 2
(which is in A1) and -2 ( which is in A4 ) in the same time , is it possible ?
thanks.......

 

[Marcelo]

Did you try the find all option? it will show yuo both.
hth
--
pleae click yes if it was helpfull
regards from Brazil
Marcelo



"pierre" escreveu:

 

[Dave Peterson]

Nope.

Maybe you could use a macro or even a formula:

Dim myCount1 as long
dim myCount2 as long
dim myRng as range
with activesheet
set myrng = .range("A1:A4")
mycount1 = application.countif(myRng, 2)
mycount2 = application.countif(myrng, -2)
end with

if mycount1 > 0 _
and mycount2 > 0 then
msgbox "Both found!"
else
msgbox "at least one not found!"
end if

 

[Shane Devenshire]

Hi,

It depends on the version of Excel you are using, the Find All option was
added in 2002.

Enter 2 in the Find what box,
Uncheck Match entire cell contents
Click Find All and look in the window below.

You can select all the hits in the window by clicking the first entry and
holding down the Shift key and clicking the last one. Then if you Close the
window all the items will be selected in the spreadsheet.

 

[Dave Peterson]

If you meant that you wanted to search for 2 and -2 at the same time, the answer
is no.

But you can search for 2 and find all occurrences of 2 (if you don't check
"match entire cell contents" under the Options buttons). This will also find
the cell with 1234523 in it.