malleshg24
01-02-2020, 07:07 PM
Hi Team,
I am using below excel formula, (range $A$2:$A$6 and Range $B$2:$B$6) Contains list of Unique names.
after applying a formula , I get result true or false, and I am deleting false after applying autofilter.
Formula:-
=OR(ISNUMBER(MATCH(A2,Criteria!$A$2:$A$6,0)),ISNUMBER(MATCH(Data!B2,Criteri a!$B$2:$B$6,0)))
I want formula should give True for blank cells as , which are highlighted in column D in Blue color.
Because I want to delete false.
Plz suggest excel formula or should I need add anything in Criteria to cover Blank cells as well.
Thanks
mg
I am using below excel formula, (range $A$2:$A$6 and Range $B$2:$B$6) Contains list of Unique names.
after applying a formula , I get result true or false, and I am deleting false after applying autofilter.
Formula:-
=OR(ISNUMBER(MATCH(A2,Criteria!$A$2:$A$6,0)),ISNUMBER(MATCH(Data!B2,Criteri a!$B$2:$B$6,0)))
I want formula should give True for blank cells as , which are highlighted in column D in Blue color.
Because I want to delete false.
Plz suggest excel formula or should I need add anything in Criteria to cover Blank cells as well.
Thanks
mg