Dos not work correct "Search" function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I use MS Excel 2002 (10.6809.6804) SP3
and have some troubles:

when I use Search function (Ctrl + F) in WorkSheet, Excel could not find
same data. Randomly it may find same or not /with same conditions of search
on same data/.
I make example (Screenshot please look here:
http://img205.imageshack.us/my.php?image=555jv4.jpg ) in my WorkSheet - I
ask Excel to look position with No 68361310 (you may see it below in sheet)
and it could not find it. Why?

Thank you for yours reply’s
 
If 68361310 is the result of a formula, you should not use Look in Formulas, but Look in Values

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hello,
|
| I use MS Excel 2002 (10.6809.6804) SP3
| and have some troubles:
|
| when I use Search function (Ctrl + F) in WorkSheet, Excel could not find
| same data. Randomly it may find same or not /with same conditions of search
| on same data/.
| I make example (Screenshot please look here:
| http://img205.imageshack.us/my.php?image=555jv4.jpg ) in my WorkSheet - I
| ask Excel to look position with No 68361310 (you may see it below in sheet)
| and it could not find it. Why?
|
| Thank you for yours reply's
|
 
Hello, Niek

thank you for your reply,

No, it's not a result of formula. It's just a figures.
 
Back
Top