View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Formula to summarize data

DataFilterAdvanced Filter.

Copy "unique records only" to another place.


Gord Dibben MS Excel MVP

On Fri, 19 Dec 2008 15:38:03 -0800, tomhelle
wrote:

I have a list of materials in column A. Some of the materials repeat in
various rows. I want to formula to summarize the list into a condensed list
of materials.

Many thanks in advance