Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default Dos not work correct "Search" function

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 he
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 replys

  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,440
Default Dos not work correct "Search" function

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

"LInc" wrote in message ...
| 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 he
| 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
|


  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default Dos not work correct "Search" function

Hello, Niek

thank you for your reply,

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

"Niek Otten" wrote:

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

"LInc" wrote in message ...
| 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 he
| 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
|



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Will the COUNTIF function work with auto-filtering? RC Excel Worksheet Functions 10 May 16th 06 11:28 PM
Which excel function would work best? Paul T Excel Worksheet Functions 1 March 1st 06 07:19 PM
I want to correct a #div/0! error but the IF function doesnt work Traceyb Excel Worksheet Functions 1 July 21st 05 03:47 PM
Does excel have a 'cubed root' function? How can it work it out? Di in Oz Excel Worksheet Functions 1 April 30th 05 12:37 AM
clock Wildman Excel Worksheet Functions 2 April 26th 05 10:31 AM


All times are GMT +1. The time now is 07:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"