Summarize data

[blstone]

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]

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