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,
FILTERING,
Resolved · Urgent Priority · Version 2003
Milton has attended:
Outlook Advanced course
FILTERING,
HI,
i need to know how to filter out 300 product codes out of a list of 5000 product cells with there codes and new prices on to a new spreadheet so i then have a list of all the matching codes (our products) we stock.
RE: FILTERING,
Hello Milton
Thank you for your post.
While we can point you in the right direction in relation to your question, any further time allocated to fulfilling your requirement will be consultative work and therefore billable.
The feature of Excel you will need to use is called the Advanced filter. You can find this in Data - Filter - Advanced Filter.
To work, the advanced filter requires three things:
- your list range (all data relating to the 5000 products you have)
- your criteria range, which you need to set up in a different area of the spreadsheet (this will contain the headings of the columns you are wanting to extract data from, most likely the column heading for your products) and the items from the column you wish to extract information from listed down the column underneath the heading
- where you want the filtered results to appear. In this instance I would advise selecting Copy to another location, then select one cell to the right of or underneath your data to copy the filter results to, which you can then copy and paste into another spreadsheet afterwards.
The link below leads to an example showing how to set up an advanced filter in Excel:
http://www.contextures.com/xladvfilter01.html
I hope this helps to point you in the right direction.
Regards
Amanda
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:Highlighting only Text cellsTo select onlt text value cells in a spreadsheet, click on Edit-Go to(F5) |