Thread: Match
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
smandula smandula is offline
external usenet poster
 
Posts: 116
Default 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