How to match exact value using match function in excel? -
i have cell value 0.00% in row , have 0 in before 0.00% in same row .
when try match =match(0.00%,$b22:$eu22,0)
. return 0 value position not 0.00% position. 1 suggest me .
before match, need convert values in range $b22:$eu22 text first. then, either use following
=match("0.00%",$b22:$eu22,0) =match("0.00",$b22:$eu22,0) =match("0",$b22:$eu22,0)
or
=match(text(b20,"0.00%"),$b26:$eu26,0)
=match(text(c20,"0.00"),$b26:$eu26,0)
=match(text(d20,"0"),$b26:$eu26,0)
to find match position. cells b20, c20, , d20 blank or zero.
Comments
Post a Comment