S
shepster
I have created a dropdown in excel 2007. This drop down contains a list of
data with many repeats, ie
A
A
A
B
B
C
D
D
How can I have a list only show a data point ONCE so it would look like...
A
B
C
D
This is important as I created drop downs dependant on other drop downs --
cleaning up these lists will improve the usability of the workbook. Thanks!
data with many repeats, ie
A
A
A
B
B
C
D
D
How can I have a list only show a data point ONCE so it would look like...
A
B
C
D
This is important as I created drop downs dependant on other drop downs --
cleaning up these lists will improve the usability of the workbook. Thanks!