f2e4
05-12-2008, 03:11 AM
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
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