I have a list box operating from a named range which
contains duplicates. I need the duplicates for later
calculations so don't want to delete them, but obviously,
don't need them showing in the list box.

Any suggestions?

Thanks, your help will be greatly appreciated.

Helen