On further research it appears that AutoFilter will only filter by 2 criteria. I have a sheet with multiple variables in Column "A". I need to filter out the criteria being less than 03-003 AND not containing "x" and not containing "Pending". Moving some data to another column to be filtered is not an option. This is a live document where rows are regularly being added so I am not sure how an array can help. Any ideas?
|