[RESOLVED] Distinct Values

From VBA, can I get just the distinct values from part of a Worksheet column ?

The part is the first 7 characters in the cell, there's always an 8th one there but that must be ignored.

Thanks, ABB

I'm sorry, English isn't my primary language, but could you be a bit more specific about "distinct values"?

Hi Opus,

Distinct as used in SQL.

my guess is not

while it is using excel, this is a straight out sql question and may be better placed in the database forum

OK Pete, It wasn't the best thought out question ! I was rushing something.... and in the end a simple few lines of basic ended up sorted it all.

Thanks, ABB

If the issue is resolved, please mark the thread as such... you can do that by using the Thread Tools menu just above post #1.

-tg