How to remove state name duplicates in combobox (excel 2010)


  • 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?

    Thursday, June 21, 2012 4:37 PM

All replies

  • Is this

    1. A Forms combo box on a worksheet,
    2. An ActiveX combo box on a worksheet, or
    3. A combo box on a userform in the Visual Basic Editor?

    Regards, Hans Vogelaar

    Thursday, June 21, 2012 5:02 PM