Good morning, I know how to use Advanced Filter to INCLUDE 'where' criteria, either OR or AND by using extra criteria cells and I've just found out how to use criteria cells M3:M4 where row 3 = "Criteria" and row 4 = "=ISNA(MATCH(B6,$M$2,0))" where M2 = 0 which excludes all the rows where Column B = 0.
Frustratingly I have had to copy and paste the successful formula to the adjacent cell's formula bar to get those to work - for some reason just dragging across and using those cells resulted in no rows being returned. I dunno!
Ah, OK just found the solution - now the cells' formulae are working: just put each subsequent criterion formula on the next line as per an inclusive advanced filter.
Just thought I'd carry on with this post anyway!
Many thanks,
D€$
Frustratingly I have had to copy and paste the successful formula to the adjacent cell's formula bar to get those to work - for some reason just dragging across and using those cells resulted in no rows being returned. I dunno!
Ah, OK just found the solution - now the cells' formulae are working: just put each subsequent criterion formula on the next line as per an inclusive advanced filter.
Just thought I'd carry on with this post anyway!
Many thanks,
D€$