Just wondered how I'd be able to match the values in column C to column A - & if there's a match, return the value "1"
i.e.
nUHzuBnsQfu7r7DOcR7bhw.png
Any questions pop em below
Ty Mdn
Just wondered how I'd be able to match the values in column C to column A - & if there's a match, return the value "1"
i.e.
nUHzuBnsQfu7r7DOcR7bhw.png
Any questions pop em below
Ty Mdn
Use COUNTIF() function:
=COUNTIF(A:A,C2)
or:
=COUNTIF(C:C,A2)
Brilliant ty Phuo, dunno how I didn't think of that![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks