Active X Combo Box - How do i stop selections repeating itself?

Are you sure you have uploaded the right workbook - there only appears to be one combobox and it does nothing.

I uploaded the wrong version by mistake, and by resaving to re-upload to here it seems to now be working :s.

Thanks

I have tried to anticipate what you are attempting to do.
I have attached a VBA alternative far more user friendly than a sheet full of formula and helper columns.
With the use of a table format it is self maintaining (no pasting extra formula etc.)
Just an insight into how easy you can make life.
torachan.