Hiding duplicates but displaying 1 of the duplicates item

We have a workbook that allow us to select a switchboard (In green box) in the "On Air Notice" 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 "Air On Notice" sheet it automatically hides duplicates but displays 1 of the duplicate item. Duplicates filter items to be picked from is "Unit Number" under the A & B column. We need to group the "A & B" columns together and if it finds a duplicate it only shows 1 item regardless of how many duplicates there are. Is this possible? I have attached our workbook to make it easier to understand.


Commissioning Test_3.xlsm

R

CB

Try this:-

Please Login or Register  to view this content.

Regards Mick

Thanks Mick worked perfectly

R

CB