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

Ron Rosenfeld wrote:
I have a spreadsheet where Sheet A contains names (including duplicates) in a
range. I'd like Sheet 2 to list the distinct names in alphabetical order.
Any ideas?

Thanks,
Dave

If you can use an add-in, you could download and install Longre's free
morefunc.xll add-in (Google for a download site), and then use his UNIQUEVALUES
function.
--ron

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