Results 1 to 9 of 9

Automatically Hide Duplicate Items

Threaded View

  1. #1
    Registered User
    Join Date
    01-18-2011
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    35

    Automatically Hide Duplicate Items

    We have a workbook that allow us to select a switchboard (In green box) in the "commissioning" sheet and it will display a list of items from "Fire Mode" sheet. What we would like to do now is when it displays the list of items on the "commissioning" sheet it automatically hides duplicates. Duplicates filter items to be picked from "Suffix" or "B column" & "#" or "C column". We need to group the "B & C" columns together and if it finds a duplicate it only shows 1 item hiding the other item. Is this possible? I have attached our workbook to make it easier to understand.

    In the attached workbook you will see 2 items are the same in the commissiong sheet for switchboard number 5.

    R

    CB
    Attached Files Attached Files
    Last edited by blacky1; 04-17-2012 at 06:33 AM.

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