data filtering

  • Thread starter Thread starter kimberly kao
  • Start date Start date
K

kimberly kao

My question is continuing with the data filter out.
What if I data I need are from different pattern explample: 28110,
28428, 37204, 37671,38778,87243,27852X, 37467A,38121M ETC... Can you
tell if there's any way I can filter them from a huge database file?

Best regards

Kimberly
 
You could add a column to your table, in which you check the code
against a list of codes --

Type the list of codes on the worksheet (or on a different sheet)
Insert a column in the main table, and add a heading, e.g. Select
In the cell below the heading, enter a formula that refers to the
list of codes (M1:M10), and the cell in the active row that
contains the code (F2):
=COUNTIF($M$1:$M$10,F2)
Copy the formula down to the last row of data
Select a cell in the table, and choose Data>Filter>AutoFilter
From dropdown in the heading of the new column, select 1
 
Back
Top