Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Excel 2003


  • Please log in to reply
2 replies to this topic

#1 ramsey76

ramsey76

  • Members
  • 227 posts
  • OFFLINE
  •  
  • Local time:06:52 PM

Posted 21 July 2008 - 01:27 PM

I have used the "find" command many times in excel with no problem.

I have a list of employee nemubers ( all numbers"

For example 91546

When I search for employee number 915646 it can not be found.

However it clear to me that number is right there ( second number in the column)

I get excel can find the data.

The formant for this coulmn is a number ( no deceimal)

What is happening ?

thanks

BC AdBot (Login to Remove)

 


#2 tos226

tos226

    BleepIN--BleepOUT


  • Members
  • 1,568 posts
  • OFFLINE
  •  
  • Gender:Female
  • Location:LocalHost
  • Local time:07:52 PM

Posted 21 July 2008 - 03:19 PM

For example 91546

When I search for employee number 915646 it can not be found.

typo? here? in Excel?

If not a typo, see if you can select a range of cells which includes what you want to find and try again.

One other check I'd do, is use Data > Autofilter on the column and see if what you look for appears in the dropdown list. If it does not, it suggests some format might be affecting it. Perhaps the numbers aren't integers? But I don't think so, because I just entered 915646.00001 in a cell and it found 915646.

Edited - on the Find dialog, click the Options button. One of those 3 settings might be different than you expected.

Edited by tos226, 21 July 2008 - 03:33 PM.


#3 randomuser83

randomuser83

  • Members
  • 18 posts
  • OFFLINE
  •  
  • Local time:04:52 PM

Posted 23 July 2008 - 01:55 PM

Make sure that when you are using the find command that you have your highlighted area on either the whole sheet, an individual cell, or the area you have selected should contain the data. As long as you have the correct info in the find area, you should 100% of the time find your data if it exists. Common issue is accidently having two cells highlighted at once when started a search, this will only look for the data in those two cells so double check you only have what you want to look into highlighted.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users