excluding duplicates from list box

[Helen Hope]

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

 

[Ron de Bruin]

http://www.j-walk.com/ss/excel/tips/tip47.htm

This will help you Helen