Thread: how do i sort a spread sheet and remove duplication
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default how do i sort a spread sheet and remove duplication
DataFilterAdvanced FilterUnique records only will return the uniques which
you can copy to another location.

For more on this see Debra Dalgleish's site

http://www.contextures.on.ca/xladvfi....html#FilterUR


Gord Dibben MS Excel MVP

On Wed, 28 Nov 2007 06:03:02 -0800, Shiraz
wrote:

I need to sort a large spreadsheet - by the column of account numbers - (over
50K) with duplications. I need to remove the duplications and keep only 1
entry of each account

Reply With QuoteReply With Quote