| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add data to cell w/o loosing initial data | Excel Discussion (Misc queries) | |||
| how to summarize and chart raw data | Charts and Charting in Excel | |||
| How to summarize data based on specific parameters | Excel Discussion (Misc queries) | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Linear Mode
