+ Reply to Thread
Results 1 to 4 of 4

Finding values

  1. #1
    Registered User
    Join Date
    05-08-2013
    Location
    London
    MS-Off Ver
    Microsoft Office 2007
    Posts
    1

    Finding values

    Hi, I have a large amount of data and am trying to find certain values.

    Firstly - I am looking for any cell which has the number 0 in it, as I need to edit that specific cell. However, when I search for the number 0, multiples of 10 (e.g. 10,20,30,etc) come up in my search.
    Is there anyway to find the number 0, without also finding the multiples of 10?

    Secondly - I am also looking for values over 100, is there a search function which allows me to do this?

    Thank you

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Finding values

    with an filter.

    But you will get better result if you add an excel file, without confidentional information.

    Please also add the desired (expected) result.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Contributor
    Join Date
    05-07-2013
    Location
    apple valley ca
    MS-Off Ver
    Excel 2007
    Posts
    110

    Re: Finding values

    =COUNTIF(A1:G14,0)

    where A1:G14 IS WHERE YOUR DATA IS WITH THE 0 VALUES.. YOU CAN ALSO US A CONDTIONAL FORMATTING TO HIGHLIGHT THE 0 VALUES

  4. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Finding values

    If you are trying to select the cells that only have the value 0 in it and no other contents, click on Find, enter 0 in the Find What field. Select "Match Entire Cell Contents". Click on Find All. A window will open listing all the cells that only contain 0. To select all those cells, click on the first cell reference and hold down the shift key and click on the last cell reference. All the cells with only 0 as the contents will be selected on the worksheet. If you are only interested in some of the cells, hold down the Ctrl key and click on each cell reference in the window that is of interest to you.

    For the second part of your problem use Conditional Formatting. Click on Conditional Formatting, Highlight Cells Rules, Select Greater Than, enter 100 click OK.

    The same process can be used to format 0 value cells.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1