I have this situation:
I have a range of columns. And I want to set indicator to '1' if any of the matching codes appear in that range. example:
C D E F G H M
1 2 3 4 5 6 if any value in range C1:H1 lie between 1-4 then 1 else 0
Say Column C1:H1, I want to create column M1(an indicator) such that any of codes say (1,2,3,4) Appear in range C1:H1 its value is set to 1 else 0
See Question&Answers more detail:os