+ Reply to Thread
Results 1 to 3 of 3

Filter has two of the same

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Excel 2016 Office 365 64-Bit
    Posts
    3,435

    Filter has two of the same

    I have a list of song titles. If filter for "Longfellow Serenade". My filter shows two identical "Longfellow Serenade"s. I select both.

    My sheet now shows two lines, with "Longfellow Serenade" on each line. I check each one for blanks, special characters, etc. They're both identical. But, to be sure, I copy the top one and paste it into the second one. So, my filter list should have only 1 "Longfellow Serenade" to select now, right?

    Nope, filter list shows two identical "Longfellow Serenade"s.

    I select the first; the two lines I got earlier appear. Hmmm!
    I clear the filter.

    I filter again, filter list shows two identical "Longfellow Serenade"s.
    I select the second; the two lines I got earlier appear. Hmmm! What's going on here?

    My worksheet has 24K lines, if I delete lines, the problem disappears, so it's not going to help to post an example.

    Any ideas?
    I know I'm not stupid, but I suspect I'm a lot stupider than I think I am

  2. #2
    Valued Forum Contributor
    Join Date
    04-26-2015
    Location
    Toronto, Canada
    MS-Off Ver
    2010
    Posts
    500

    Re: Filter has two of the same

    Based on your description it sounds like you need to CUT & PASTE not Copy & paste for your test. Cut will remove 1 of the entries and leave the cell blank. Or, why don't you just delete the extra entry in the 1st place?
    Uploading an attachment will assist Forum Members in finding the correct Solution for you. Create a dummy worksheet if necessary, add your start data and show where / what your expected results should be. TO ADD A FILE:

    Go to 'Advanced. click on 'Manage Attachments. Select 'Browse & Choose your file, Select 'Upload and then close the Attachment window.

  3. #3
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Excel 2016 Office 365 64-Bit
    Posts
    3,435

    Re: Filter has two of the same

    For "why don't you just delete the extra entry in the 1st place?" the full data set is all the MP3s I have on each of my CDs, to see where I have duplicates. In this case it's in the "Title" column only. I'm slowly weeding through and deleting the dupes, while trying to make sure I don't delete anything I have only one copy of. So, first level is song title, followed by Artist. I'm using Pivots and filters to fine tune, and happened to notice this filter glitch just this morning. But I've resolved the issue by killing and reestablishing the filter.

+ 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. Inserting filter into pivot table via macro errors if filter doesn't exist.
    By taylorsm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-03-2018, 10:24 AM
  2. VBA Advanced Filter - Two Filters Without Deleting Bottom Filter Data In Same Column Range
    By hysterical.useless in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-14-2017, 02:54 PM
  3. Macro to filter a pivot whilst looping through filter criteria in a variable list.
    By Alistairm88 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-29-2015, 04:25 AM
  4. Replies: 6
    Last Post: 10-16-2014, 08:42 AM
  5. Need to filter a report filter based on the previous filter
    By elliotencore in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-28-2014, 07:44 AM
  6. Change Pivot table Filter Based on Cell Value *Multiple Filter items* Possible?
    By Flydd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2012, 06:57 AM
  7. Filter several pivot tables by one programmed date range filter in Excel 2003
    By olewka in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2011, 11:49 AM

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