How to remove state name duplicates in combobox (excel 2010)
-
Thursday, June 21, 2012 4:37 PM
I am currently working a project where I need to link a combo box to a list of states in another sheet. I am familiar with how to link this but I want to remove the duplicate state names without removing the other data associated with that state (like revenue and expense which are simply in the columns following state name)
How should i do this?
.png)
