List Disctinct Strings from Range of Cells

[Max]

Try this sample construct which proves it beyond words:
http://cjoint.com/?jrpvHasO1Z
AutoList Unique Names in Alpha sort.xls

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik

 

[golddave via OfficeKB.com]

I have it working now. Good stuff. I see what you mean about the way it
alphabetizes. Is there a way to get it to alphabetize better?

 

[Max]

Welcome. Suggest you start a new thread just focusing on the true alphabetic
sort issue. To recollect, what I gave earlier does perform both
functionalities that you seek in one go: List uniques and alpha sort by 1st
letter
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik

 

[Sunir M S]

Why don u try this. It was in another post. List the distinct strings in one
coloumn on a seperate worksheet . match ur main sheet with all the strings
against this and make it return yes/no depending on the string matches.
Filtering trues will give you only the distinct strings and then do a simple
sort..

http://www.microsoft.com/communitie...&p=1&tid=4972a297-0943-4c3c-b845-dc6c1c4d0c36