Finding Skips

[cherokee]

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

<colgroup><col></colgroup><tbody>
</tbody>

 

[Rick Rothstein]

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

<colgroup><col></colgroup><tbody>
</tbody>

I am not sure exactly what you mean by "skips" (especially since there seems to be two columns of data involved)... can you show us some representative samples of what kind of data you have for your numbers case and then show us the same thing for your letters question?

 

[cherokee]

You have one column with 15000 rows. If you want (example 0) to find how many rows between each time the 0 shows up. The BC$5 in the formula is where the number is located that you are looking for. I need a formula that is made up of alphabet letters in place of numbers. Example (DN)
Thanks