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/communities...5-dc6c1c4d0c36


--
Sunir M S




"golddave via OfficeKB.com" wrote:

Requirements are set by clinet. Cannot be changed.

Ron Rosenfeld wrote:
I tried that dll once and when I uninstalled it the system it was on got
messed up.

So far you have told us that:
cannot use Advanced Filter because of the shape of your data.
cannot use Advanced Filter because your users cannot run the filter.
require dynamic updating.
Client does not allow macros.
Will not use morefunc.xll because a system got messed up when you
uninstalled it.

I've installed and uninstalled morefunc.xll -- which, by the way, is an "XLL"
and not a "DLL" as you wrote above, with nary a problem. There are some
features which do not work in Excel 2007, but the UNIQUEVALUES function does
work.

I think you will have to modify your requirements.

The morefunc.xll add-in will surely do what you want. But if that is not
acceptable, you will probably need to either develop a secure way of using a
macro that satisfies your Client, or find another tool.
--ron

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200909/1