On Wed, 16 Sep 2009 18:02:16 GMT, "golddave" <u54833@uwe 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