+ Reply to Thread
Results 1 to 2 of 2

Find values NOT equal to x

  1. #1
    Registered User
    Join Date
    04-25-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1

    Find values NOT equal to x

    Hello,

    There has to be a way to do this, but I have not figured it out yet. I'd appreciate your help.

    I want to find (and replace) all values in my spreadsheet that are not equal to 0 or 1.

    This question, then, has two components: 1.) how do I perform a "find" that locates values not equal to something (e.g. 1), and 2.) how do I perform a "find" that locates values not equal to something (e.g. 1) OR something else (e.g. 0)?

    From what I can tell, the "find and replace" dialog isn't very flexible and can't handle these kinds of conditional searches. Perhaps I'm wrong. But if I'm right, is there another way to do it that doesn't use the "find and replace" dialog?

    Thanks very much in advance.

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Find values NOT equal to x

    You are correct, I don't believe there is a way to do it with Find/Replace.
    Are these values all in the same column? If not, what sort of range are we looking at?
    Are you replacing all of them with the same value or text?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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