Prev: Filtered Counif
Next: function help for counting text as a value....
From: Sunir M S on 10 Dec 2009 23:18
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/newsgroups/en-us/default.aspx?&lang=&cr=&guid=&sloc=en-us&dg=microsoft.public.excel.newusers&p=1&tid=4972a297-0943-4c3c-b845-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.aspx/excel-functions/200909/1
>
>
 | 
Pages: 1
Prev: Filtered Counif
Next: function help for counting text as a value....