MATCH?

A

Annette

I have 10 columns/1 row that have different numbers. I want the 11th column
to match for a specific number if found. Here's an example with expected
result

1 2 3 4 X
a c x e 1
t a e k 0
x b i l 1

X=result

Can someone help me with the formula? Thanks!
 
K

Kevin Vaughn

Probably the simplest formula would be
=COUNTIF(A2:D2,"x")
of course, change range to reflect your 10 columns. Note: the number would
change if there were more "x"s in the row. If that matters, you would
probably want to include an IF test to change it to 1.
 
Top