View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mthakershi mthakershi is offline
external usenet poster
 
Posts: 1
Default Searching large excel files

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