Summarize data

I have a spreadsheet with lots of data fields. In one column of data there
are several repeating titles. Is there a way to get a list of these where
each title only appears once? Then can I copy it to a new sheet as a
reference?

You can use an Advanced Filter to export a unique list of items. There
are instructions in Excel's Help, and here:

http://www.contextures.com/xlaÂ*dvfilter01.html


blstone wrote:
> I have a spreadsheet with lots of data fields. In one column of data there
> are several repeating titles. Is there a way to get a list of these where
> each title only appears once? Then can I copy it to a new sheet as a
> reference?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html