Forum home » Delegate support and help forum » Microsoft Excel Training and help » Filtering Data
|
|
|
The UK's most regular 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. |
Filtering Data
Resolved · Low Priority · Version Standard
Reply Wed 6 Feb 2008, 11:21Delegate Paula said...
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?
For upcoming training course dates see: Pricing & availability
Reply Wed 6 Feb 2008, 12:05Delegate Paul said...
RE: Filtering Data
try data > filter > auto filter...
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
|