Excel Help

Closed
Report
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
Hello,

What is the formula for:

If any cell in column B is in Column A, then display 0, if not 1, in C

Thank you.

1 reply

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi Jill,

Try this:
=SUM(IF($B$1:$B$6<>A1,1,0))-5
This is an array formula and needs to be confirmed by hitting Ctrl+Shift+Enter.

I used 6 rows of data resulting in $B$1:$B$6, adjust this to suit your range.
You also need to adjust the final number at the end. This number should be 1 less of the total number of rows used. In my case 6-1=5.

Best regards,
Trowa