ctrl+F
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....... |
ctrl+F
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: 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....... |
ctrl+F
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 pierre wrote: 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....... -- Dave Peterson |
ctrl+F
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. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "pierre" wrote: 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....... |
ctrl+F
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. Dave Peterson wrote: 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 pierre wrote: 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....... -- Dave Peterson -- Dave Peterson |
All times are GMT +1. The time now is 01:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com