Posted to microsoft.public.excel.worksheet.functions

golddave

external usenet poster

Posts: 4

List Disctinct Strings from Range of Cells

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Detect strings in a range	Rich57	Excel Worksheet Functions	4	January 1st 08 12:00 AM
List disctinct values	cindi	Excel Worksheet Functions	10	August 16th 07 12:24 AM
strings in a range	Peter Morris	Excel Worksheet Functions	4	September 5th 06 01:00 AM
How to find number of pairs of strings from list of strings?	greg_overholt	Excel Worksheet Functions	5	January 27th 06 10:42 PM
Condensing a list/range with blank cells to a new list/range without blanks	KR	Excel Worksheet Functions	4	July 5th 05 04:23 PM

All times are GMT +1. The time now is 11:30 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us