Filtering Data

I am struggling to figure the best way to filter a very large set of data. I need to filter it by one of the columns titles Style. I would like to filter the data so that I only have 373 of 2,000 styles. I have a list of the styles I want, but the styles occur more than once in the raw data. (there are multiple rows with the same style) which I think prevents me from using vlookups. Goving through a filter and selecting the styles I want seems tedious and prone to error. Anyone know of a better way?

Hi,

Sorry - it's not quite clear what you mean. So some or all of the 373 Styles that you wish to display are not unique in the raw data? I mean, let's say for the sake of argument that 26 of your 373 desired Styles are called Style1 - are you saying there may actually be greater than 26 occurrences of Style1 in the raw data? If so, what other criteria would you use to differentiate these 26 from the rest?

There are 2,000 unique styles of which I interested in a subset of 373 unique styles out of those 2,000. In the raw data any 1 of those styles, Style1 for example, could occur many times. There could be 50 Style 1's and 4 Style 373's. What differentiates them is values in different columns. However, it isn't necessarily the same column. 1 style could have 5 rows with the same date but different quantity values and 10 rows with different dates but the same quantity value. Each row is unique in some way.

I would like to pull all of those rows that have the same unique style number and remove the rows that do not have one of the styles in my list (the 1627 other styles). I don't want to combine all the same styles into 1 row, but leave each of the rows with that style value as a separate row.

Can you post a sample of your workbook and perhaps illustrate your desired result?