+ Reply to Thread
Results 1 to 4 of 4

Multiple Filter by Cell Values

  1. #1
    Registered User
    Join Date
    01-16-2004
    Posts
    5

    Multiple Filter by Cell Values

    Hi All,

    I have a worksheet where I want to keep duplicate entries and compare all duplicate entries.

    all entries are in Column A. I have it set with conditional formatting so when I type in a new entry it highlights the duplicate red (the default color). then I can manually use the filter to search for the entry and compare both rows side by side.

    but if I have several duplicates instead of filtering through each one at a time I would to select a group of duplicates and do one filter for all duplicates.

    I left two images in the attachments

    first image: column A, all the red entries are duplicates.
    Second image: I filtered one of the entries (row 9981) to compare with the duplicate (which was in row # 7754)

    but what if I select a group of duplicates (lets says from row 9981 to row 9985), is there anyway I can filter groups of duplicat6e entries instead of one by one.

    I tried searching google, but I think I don't have the terminology right and cant seem to find what I need.

    thanks

    Eric Hansen100.jpg200.jpg
    Last edited by EHansen; 06-29-2015 at 04:31 PM.
    Eric Hansen

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Multiple Filter by Cell Values

    You could maybe use something like the array index/small/if to pull out all duplicates in "B" that match a specific criteria in "A".

    However, Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
    Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

    Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    01-16-2004
    Posts
    5

    Re: Multiple Filter by Cell Values

    Thanks

    attached an example.

    /Eric
    Attached Files Attached Files

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Multiple Filter by Cell Values

    Im not really sure what you here Your sample does not really match the description you gave - can you show what you want the outcome to look like, and how you arrived at that?

    If you mean, you want to filter on more than just 1 value, you can select however many items you want to filter on

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 11-15-2013, 11:25 AM
  2. Filter rows based on cell values in multiple columns
    By dionaqld1 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-25-2012, 09:13 AM
  3. Filter or sort multiple values in a cell
    By kingtut in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-03-2007, 06:12 AM
  4. Filter: Multiple values in a cell
    By pandora in forum Excel General
    Replies: 1
    Last Post: 12-06-2005, 03:10 AM
  5. [SOLVED] How do I Auto-Filter with multiple values in a cell in Excel?
    By Burghthing in forum Excel General
    Replies: 2
    Last Post: 11-23-2005, 12:45 PM

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