Home |
Search |
Today's Posts |
#1
|
|||
|
|||
removing duplicates
Hi I would like to be able to limit the contents of a listbox on my form not to show duplicates. The only way I know how to enter the properties of the listbox is through clicking the cell, then data then validation. in the options I have checked list then ignore blanks incell drop down are both checked I have source down as =$A$14:$A$502 can I change the value of source to take out duplicates Thanks Rob -- robhargreaves ------------------------------------------------------------------------ robhargreaves's Profile: http://www.excelforum.com/member.php...o&userid=25519 View this thread: http://www.excelforum.com/showthread...hreadid=389608 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing Duplicates | Excel Discussion (Misc queries) | |||
Removing Duplicates | Excel Worksheet Functions | |||
help removing duplicates for mail merge | Excel Discussion (Misc queries) | |||
Finding Duplicates | Excel Worksheet Functions | |||
removing duplicates testing in 2 coloms | Excel Worksheet Functions |