Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excluding duplicates from list box
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
excluding duplicates from list box
http://www.j-walk.com/ss/excel/tips/tip47.htm
This will help you Helen -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Helen Hope" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding all unique rows and excluding all duplicates | Excel Discussion (Misc queries) | |||
Count a value excluding duplicates depending on a set criteria | Excel Worksheet Functions | |||
Sumproduct excluding duplicates with added condition?? | Excel Worksheet Functions | |||
Requesting Help with Counting in a Pivot but Excluding Duplicates | Excel Worksheet Functions | |||
Count excluding Duplicates | Excel Worksheet Functions |