Simple excel report

I have never worked with excel before simplequestion but just need to get this done ASAP.
There is a sheet which has 40000 plus records
col1   col2   col3   col4 col5


I need to pull out data (rows)from this sheet into a new one such that value of col3 is in (val1,val2,val3,val4,val5,val6,val6,val8,val9,val10)  I should be getting approx 20000 records. How do I do this in excel.

YRKS
SMadhaviAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Glenn RayConnect With a Mentor Excel VBA DeveloperCommented:
Am I correct in re-stating your problem like so?

You have a worksheet with five columns of data.  You want to see (i.e., copy/move) only the rows where the third column contains a specific set of values.  Your example lists ten possible values.

If you are using Excel 2007/2010, you can use an auto-filter to view only those values.  Or, you can use the same auto-filter to view all values except those and then delete those rows, leaving only the ones you want to view.

To turn on filters: click "Data" in the menu on top, then click the "Filter" icon. Small drop arrows will appear on the top row.  Click the drop arrow to see values in that column and filter from there.  You can select individual items via check boxes or use more general filtering (ex., number or text matching).

See the attached workbook as an example.  The data is filtered to show only  rows where Column3 values are 1,2,3,4, or 5.

-Glenn
EE-DataFiltering.xlsx
0
 
Simon BallCommented:
put autofilter on the sheet - in data, filtering, then filter column three, go to custom and create the custom filter..

then once filtered, copy and past the records into a new sheet.
0
 
Simon BallConnect With a Mentor Commented:
depending on the values you might be able to get clever with the customer filter using "contains".

for a large record set, and because i am used to access and sql, i would import the data set into access or sql, and write a query to return the records....

you can highlight the data set and go to data, advanced filter, it lets you specify a criteria range... e.g. cella a1..a10 to contain your search values....
0
 
Simon BallCommented:
beaten to it with longer post :P
0
 
SMadhaviAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.