+ Reply to Thread
Results 1 to 4 of 4

Filter out Matching Criteria

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    05-29-2009
    Location
    Kalgoorlie Australia
    MS-Off Ver
    Excel 2007/10
    Posts
    251

    Re: Filter out Matching Criteria

    Hello
    Please have a look.
    It will add a 1 into any that is found on sheet 1.
    If this is what you are after then you just need to "DATA SORT" and that will group them together.
    Again if it is ok and you want a macro to DATA SORT I'll have a look later, please send me a private message to let me know what you want to do.
    I noticed all your numbers are stored as text, any reason why.
    I didn't have time to see if this has effected the result; if in sheet 1 it istext and sheet 2 is a number, or a mixture of both, if this is the case, we will to change need them to a number.
    I really have to go now.
    Regards
    Peter
    Attached Files Attached Files

+ 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