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





"mthakershi" wrote:

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