View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hafeez Esmail Hafeez Esmail is offline
external usenet poster
 
Posts: 22
Default Select rows contain Xin Column Y

I have a large amount data that gets dumped into a CSV
file every week where 40% of it is useless to me.
Sample data:
Column A = Date, Column B = Time, Column C = Division,
Column D = Group, E = Function etc..

The pseudocode for what I'd like to do is:
1) Select all rows that contain HR in Column C that
contain Hiring in column D OR Training in column D
2) Delete the selected rows

Thanks
Hafeez Esmail