+ Reply to Thread
Results 1 to 2 of 2

Filtering based on first 2 numbers in sequence

  1. #1
    Registered User
    Join Date
    11-08-2006
    Posts
    1

    Exclamation Filtering based on first 2 numbers in sequence

    Hi,

    I have a spreadsheet with around 13,000 rows of data, one colum is a mixture of 7 and 8 digit numbers. I want to filter numbers out based on the first 2 numbers in the cells.

    eg.

    10220063
    15220278
    17220307
    6220367
    7221138
    7221140

    I want the cells that start with 15 to be excluded.

    Im sure this is possible but just cant remember how to do it!!!
    Thanks in advance!

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    Use Custom and input your own criteria not equal to 15* ...

    HTH
    Carim

+ 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