Simple excel report
Posted on 2012-03-19
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.