+ Reply to Thread
Results 1 to 2 of 2

Advanced Filtering question

  1. #1

    Advanced Filtering question

    Hi folks,

    I have a huge spreadsheet here in work that contain information on about 100 projects we are working on. I have an auto filter in the project category to sort each project from the 9000 rows of information. Quite a large on as I said

    I was wondering if there was a way to create a filter to show only one example of each project? ie. instead of selecting 'project1' from the list and seeing every instance of that project I can select an option that will show only one of every available project?

    Is this even possible?

    Thanks a million in advance?

    PS: If anybody know of a macro that would do the same thing do you know where I could find it?

  2. #2
    Forum Moderator dominicb's Avatar
    Join Date
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365


    Good morning Ionize

    Try using advanced filter. Say you data range occupies A1:D1000, then highlight A1:A1000 and go to Data > Filter > Advanced Filter.

    Use the option to filter the list in place, make sure that the list range is A1:A1000 (it might try and default to A1:D1000), leave the criteria empty and tick the box to show unique items only and click OK.


    Please familiarise yourself with the rules before posting. You can find them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1