i attempting create if statement use contents of cell (a1) within range (g2:g11), if found show word "multi", otherwise blank "".
the formula attempting use =if(a2=g2:g11,"multi",""). can find first number within range, no other number within range when tested it. appreciated. in advance.
a simple countif
it:
=if(countif(g2:g11,a1),"multi","")
Comments
Post a Comment