Match
 

Having trouble with the second match, in that
1 first real match
0
0
1 is considered the first match after a zero
1 is the quoted second match five items down
0
0
0
1

How do you ger around this problem, using
= MATCH($L$12,$K$14:$K:$22,1)

$L$12 is the criteria and is boolean 1

With Thanks

Match
 

Maybe the answer on the seond match is to start down one cell.



Having trouble with the second match, in that
1 first real match
0
0
1 is considered the first match after a zero
1 is the quoted second match five items down
0
0
0
1

How do you ger around this problem, using
= MATCH($L$12,$K$14:$K:$22,1)

$L$12 is the criteria and is boolean 1

With Thanks

Match
 

can you please explain a little more what you're trying to accomplish?

--


Gary


"smandula" wrote in message
...
Maybe the answer on the seond match is to start down one cell.



Having trouble with the second match, in that
1 first real match
0
0
1 is considered the first match after a zero
1 is the quoted second match five items down
0
0
0
1

How do you ger around this problem, using
= MATCH($L$12,$K$14:$K:$22,1)

$L$12 is the criteria and is boolean 1

With Thanks

Match
 

What I am trying to accomplish is to find the row value according to
the list of Boolean 1 and 0.

Using match the first Boolean 1 identifies the row. The second Boolean 1 is
separated by Boolean 0, two 0's in this example making the 5 instead of 4.
By subtracting 1 from the formula the result is correct. That is 4.

I am only guessing at this solution. Any thoughts?

Bye for Now.

--


Gary


"smandula" wrote in message
...
Maybe the answer on the seond match is to start down one cell.



Having trouble with the second match, in that
1 first real match
0
0
1 is considered the first match after a zero
1 is the quoted second match five items down
0
0
0
1

How do you ger around this problem, using
= MATCH($L$12,$K$14:$K:$22,1)

$L$12 is the criteria and is boolean 1

With Thanks