Distinct Values

Hey All,

I have the code below which parses through about 16000 rows with 3 columns. ID/COUNTY/STATE

It output in an adjacent column each ID then each county(s) they are associated with.

Output is ID in Column E and the in Column F, eash STATE.COUNTY seperated by commas..

example:

222 CA.SACRAMENTO, CA.LOS ANGELES, CA.SAN DIEGO
235 NY.SUFFOLK
242 AK.ANCHORAGE

etc..

But for some IDs they have multiple identical STATE.COUNTY data, and I cannot figure out how to retreive only DISTINCT(UNIQUE) STATE.COUNTY values.

example:

221 CA.LOS ANGELES, CA.LOS ANGELES, CA.LOS ANGELES, CA.LOS ANGELES

I would want only:

221 CA.LOS ANGELES

Please Login or Register  to view this content.

Hopefully that all makes sense..

Thanks in advance for any help!

Try looking at this example: http://www.j-walk.com/ss/excel/tips/tip47.htm

Although the example is most famously used for getting unique items into a combo or list box, I have used this in many, many, many different situations to extract a unique collection of text items.

Hope it helps.