98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Filtering Data
Filtering Data
Resolved · Low Priority · Version Standard
Paula has attended:
Excel Introduction course
Filtering Data
I am working a lot with percentages and names which may appear more than once and i am trying to filter out the names to create a spreadsheet. How do i go about this?
RE: Filtering Data
Hi Paula,
If it's only just a column of names that you would like to copy to a new spreadsheet, then use ADVANCED FILTER.
- 1. Open your workbook file
2. On the original file, select DATA menu > Filter > Advanced Filter
3. Under ACTION: select Copy to another location
4. Click in the "List Range" box, select the full Name list
5. Click in the "Copy To" box, click on a cell of an empty column
6. Click on the checkbox "Unique Records Only"
7. Press OK
8. You should see a list of unique names from your table copied to this empty column
9. Highlight the selection, cut & paste them to your name file
Hope this helps.
Regards,
Katie Woo
Microsoft Certified Trainer
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Move or Highlight CellsUse any of your movement keys, cursor, Home, End, PgUp or PgDn to highlight cells rows or columns by holding down the Shift key as you move. |