MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Combo box with all unique entries

Posted by John on November 25, 2001 7:49 AM

I have duplicate data in my rowsource that I am feeding to a combobox. Is there a way to only show unique and non empty data?


Posted by Aladin Akyurek on November 25, 2001 8:44 AM

Apply Adv Filter for example to your source data in order to eliminate duplicate data.