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