Filtering data

[mcraft]

I am trying to filter a list of data.
I have 12 columns and approx 10,000 rows of raw data.
Column 2 contains the part number.
I have a seperate list of about 700 part number and I would like to see the data for only thes part numbers.
Is there a formula or funtion to filter out this report for only the part numbers I want.

[swatsp0p]

Here is one way to accomplish your task, using VLOOKUP and AutoFilter...

First, name your list of 700 part numbers as TABLE (or some such name)[highlight the range, click Insert>Name>Define and give it this name. Make sure this list is sorted in Ascending order (this is VITAL)

Next, on your main sheet, insert a new column C next to your Parts Number column. Give this a Heading name of Hit List (or whatever)...also make sure every one of the (now) 13 columns has a descriptive heading of some type. Assuming this will be Row 2 for all columns.

In the top row of this new column (assume this is C3) enter this formula:
=IF(VLOOKUP(B3,TABLE,1,1)=B4,1,"") and copy down the entire range of your data. (you should see up to 700 rows that have a 1 here, the rest will be blank)

Next, select any cell in your header row click Data>Filter>autofilter

Notice that each Heading now as a small down arrow in it's cell. These allow you to "filter" by the choices in the dropdown box for each column. Click the arrow in your Hit List column and click on the 1

All rows that do not have a 1 in this column will be hidden (you can then copy the remaining data to another sheet if you like)

When finished with this task click the down arrow again and select "All" to bring back all the data that was hidden.

Good Luck