How to match two columns in Excel -
i trying match 2 columns, column (2, 3, 4, 5, 5, 6, 7) , column b (2, 3, 4, 5, 6, 7) using if(iserror(match(a1,$b$1:$b$8,0)),"",a1)
.
the formula matches values correctly fives. match both 5's in column single 5 in column b. whereas expected pick 1 5 in column , matching in column b leaving other 5 pending. have alternative formula 1 above? thanks
assuming copying formula down in column, use countif see if number has occurred in column:-
=if(or(iserror(match(a2,$b$2:$b$7,0)),countif(c$1:c1,a2)),"",a2)
(i adding headers , starting in row 2).
Comments
Post a Comment