Match

[smandula]

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

[smandula]

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
>
>

[Gary Keramidas]

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

--


Gary


"smandula" <smandula@idirect.com> wrote in message
news:WJidneG8sf7jd6DeRVn-gw@look.ca...
> 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
>>
>>
>
>

[smandula]

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" <smandula@idirect.com> wrote in message
> news:WJidneG8sf7jd6DeRVn-gw@look.ca...
>> 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
>>>
>>>
>>
>>
>
>