+ Reply to Thread
Results 1 to 3 of 3

filtering based on two conditions

  1. #1
    Registered User
    Join Date
    10-08-2010
    Location
    MK, UK
    MS-Off Ver
    Excel 2003
    Posts
    70

    Smile filtering based on two conditions

    Hi

    I would like to add some code to an existing macro that will filter the data in the attached in a example workbook.

    I would like to filter out all the data I have marked in red text ( not normally like this ).

    The data varies in amount from day to day, in column A there is some matching data, i.e. A3 matches A4, both have a 1 next to them in B3 and B4 this would need to be removed, but also A10,A11 and A12 match each other and have 1 in the corresponding rows in column B this would also be removed.

    Im not sure where to start ?

    Thanks
    Attached Files Attached Files
    Last edited by davidparkes; 02-09-2011 at 03:28 AM.

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: filtering based on two conditions

    Hi

    See how this goes.

    Please Login or Register  to view this content.
    or using a filter

    Please Login or Register  to view this content.

    rylo
    Last edited by rylo; 02-08-2011 at 08:25 PM.

  3. #3
    Registered User
    Join Date
    10-08-2010
    Location
    MK, UK
    MS-Off Ver
    Excel 2003
    Posts
    70

    Re: filtering based on two conditions

    Hi Rylo

    Many thanks, the first code worked perfect.

    I will mark it solved and to your rep..

    Cheers
    David

+ 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