Hello,

I need to find the number of cells between the second and third values. Below is an example:

<tbody>

</tbody>

So, for row 2, I'd like the formula to return an answer of 3. For row 3, I'd like it to return 2. I have two other columns that help a little by providing the values of the second and third values (for instance I2 would show "2" and J2 shows 15). With these extra columns that identify the second and third values, I used this formula with some success: =ABS(MATCH(I2, (A2:H2, 0)-MATCH(J2, A2:H2, 0)).

However, that formula does not work with A3:H3 from my example. The reason is because the second and third values are the same (9 and 9), therefore cells I3 and J3 are the same.

Thanks in advance!

I need to find the number of cells between the second and third values. Below is an example:

A | B | C | D | E | F | G | H |

5 | 2 | 15 | |||||

8 | 9 | 9 |

<tbody>

</tbody>

So, for row 2, I'd like the formula to return an answer of 3. For row 3, I'd like it to return 2. I have two other columns that help a little by providing the values of the second and third values (for instance I2 would show "2" and J2 shows 15). With these extra columns that identify the second and third values, I used this formula with some success: =ABS(MATCH(I2, (A2:H2, 0)-MATCH(J2, A2:H2, 0)).

However, that formula does not work with A3:H3 from my example. The reason is because the second and third values are the same (9 and 9), therefore cells I3 and J3 are the same.

Thanks in advance!

Last edited: