Extract specified fields with criteria from Excel.cvs workbook

[EricB]

I have a workbook consisting of some 35 columns & close to 60.000 rows.

We need to extract certain rows (excluding unwanted data/columns) by
specifying a specific characteristic/s

Any ‘basic’ formula that I can implement?

Regards

EricB

 

[Max]

IMO, easiest to use autofilter. Apply whatever criteria to filter out the
data subset. Then copy the entire sheet (as filtered), do a paste special as
values in a new sheet (only the filtered subset will get pasted over). Then
just clean up by deleting whatever unwanted cols within that new sheet to
arrive at the desired output.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik

 

[Ashish Mathur]

Hi,

You may also use Advanced Filters.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Max]

.. Then copy the entire sheet (as filtered), do a paste special as

values in a new sheet (only the filtered subset will get pasted over).

The above behaviour applies in my xl 2003. Hazily recollect some postings
that it doesn't quite work that way in xl2007. Just a clarification for the
record.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---