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