Thread: list unique values in a list
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default list unique values in a list
DataFilterAdvanced Filter.

Copy to new location and Unique records only

For more on this see Debra Dalgleish's site.

http://www.contextures.on.ca/xladvfilter01.html


Gord Dibben MS Excel MVP

On Wed, 15 Oct 2008 18:14:07 -0700, bobby769
wrote:

I have a list of vendor names with some names repeated.
How do I get a listing of all vendor names?

Reply With QuoteReply With Quote