[TABLE="width: 29"]
<colgroup><col></colgroup><tbody>[TR]
[TD]=MATCH(BC$5,INDIRECT("A"&SUM(BB$15:BB15)+1&":$A$10000"),0)
This formula works when finding skips between numbers. Is there a formula for finding skips between letters?
[/TD]
[/TR]
</tbody>[/TABLE]
<colgroup><col></colgroup><tbody>[TR]
[TD]=MATCH(BC$5,INDIRECT("A"&SUM(BB$15:BB15)+1&":$A$10000"),0)
This formula works when finding skips between numbers. Is there a formula for finding skips between letters?
[/TD]
[/TR]
</tbody>[/TABLE]