ExcelBanter - Summarize data

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Summarize data (https://www.excelbanter.com/new-users-excel/25756-summarize-data.html)

blstone

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?

Debra Dalgleish

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

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

All times are GMT +1. The time now is 06:39 AM.