Remove Duplicates in ComboBox

[Freddy]

Hi Guys,

I have created a Combobox on on 'Sheet1' thats displays a drop down from
'Projects'

As the length of the list on 'Project list' will change over time, i have
used the following function for the name range:

=OFFSET(Projects!$C$4,0,0,MATCH("*",Projects!$C:$C,-1),1)

The problem:

The data on 'Projects' has a list of every project and a name beside it.
However, there is many names for each project resulting in a sheet with lots
of duplicate projects.

When i open the drop down in the combobox, all of these duplicates are
displayed.

Is there any way of removing the duplicates from the drop down list and
displaying only 1 entry for each project?

Thanks in advance

F

 

[Ed Ferrero]

Hi Freddy,

Build a pivot table based on the name range you defined with OFFSET

Put project name in the row area, count of project name in data area

Base the combo box list on the first column of the pivot table

Ed Ferrero
www.edferrero.com