Searching large excel files

  • Thread starter Thread starter mthakershi
  • Start date Start date
M

mthakershi

Hi,

Can someone suggest me a tool that can search huge excel files like a
database and display/print results? I have CSV files with thousands of
records. I want to search rows based on a specific criteria that
involves different columns and conditions.

For example:
[Column A between 6/1/2000 and 6/1/2007] AND [Column B like '%thakershi
%' or Column B like '%shah%'] AND [Column C >= $60,000]

This is just one example. The conditions keep changing based on what
is required.

Any help is welcome.

Thank you.

Malay Thakershi
 
Take a look at Data > Filter > Autofilter > Custom, and set up the criteria
you wish to filter by..........

If this is satisfactory, and done frequently, it can be automated with a
macro(s).

Vaya con Dios,
Chuck, CABGx3
 
Back
Top