Results 1 to 4 of 4

Thread: College Data Help

  1. #1

    College Data Help



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    Is there a way to use a wildcard search or query on a data range, but the constant part not be at the beginning? For example, I want to find any number with a "14" in the 5-6th position in a 13 digit number (5305144222096).

    Does anyone have an idea on how to do that?

    Thank you,

    ALW2675

  2. #2
    Good afternoon,

    I'm not sure about a query, but you could use a conditional format. Highlight the entire range and then use the conditional format option where you use your own formula. Then use:

    =mid( --- top left cell, as a relative reference --- , 5 , 2 ) = "14"

    and then set your format.

    This won't query all of the data, but it will highlight favorable occurrences, then you can filter by color or whatever.

    I'm sure there is a better way, but I would need to see your source data (or perhaps one of true guru's will wander by ).

    Best of luck,

  3. #3
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Location
    Australia
    Posts
    184
    Articles
    0
    Took a while to wander but I think you are looking for "????14" :-)
    Look at http://office.microsoft.com/en-au/ex...005203612.aspx
    and also possibly http://office.microsoft.com/en-au/ex...010062577.aspx

  4. #4
    Thanks, guys! Your responses were very helpful.

Tags for this Thread

Posting Permissions

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