List Box again...

Posted by Bob J on October 19, 2001 6:46 AM

My last message didn't take! Look at List Box - Bob

Anyway, My question is, can you make a distinct list
inside a List Box. Currently I use the RowSource (Report!A:A)
for the data, but I have multiple occurances of the same item.
I only want it to show one time. Example:

Current Need
ABM ABM
ABM MMM
ABM
ABM
ABM
MMM

Thanks in advance..Bob

Posted by Barrie Davidson on October 19, 2001 7:51 AM

Bob, how about filtering your data on unique values, placing these values in another column and using that column for your input source? For example, select your data in column A and then select Data|Filter|AdvancedFilter. Select "Copy to another location" for the action, put B1 in the "Copy to" box and check "Unique Records Only". Then change your input source to B2:B300 (or whatever). Note that you need a header row to perform and Data functions (such as filtering).

Hope this helps you out.

BarrieBarrie Davidson