VBA several IF AND OR criteria

[warp765]

Hi All

I'm trying to filter a sheet on several criteria but I can't get the results that I want so far. I also don't know how to check number of words in a cell. Any help appreciated!


If Column C contains Type1 Then
=================================================================
If Column E is blank OR If Column L contains value in TechArray then ignore row
=================================================================
If Column E contains <=2 words and (Column E does not contains “meter” or “flow”) and (Column G, H or I is blank or contains “Unknown” ignore row
OR
If Column E contains <=2 words and (Column E contains “meter” or “flow”) and (Column G is blank or contains “Unknown”) ignore row
================================================================
If Column E contains >2 words ignore row copy row

Please Login or Register  to view this content.

[ORoos]

Hi Warp,
It may be useful if you attach a sample file (without confidential data), allowing a clearer picture on the raw data and showing the expected outcome. in a second tab.

[warp765]

Hi there,

Thanks for the reply. Ive attached my workbook with the full code and removed confidential info. The if criteria I mentioned that I need help with for 'Type3' is near the top of the module.

The first tab is the raw data and the rest are the results. Thanks!