I need a help formula

[Khaled]

Hi,

I need a formula to help on the following:

I have this range of numbers: 43, 50, 57, 66, 76, 87

And if I entered 43 in a cell and 76 in another cell, I need a 3rd
cell to tell me that the distance is 4 steps!

Thanks in advance.

Khaledity

 

[Ron Rosenfeld]

Hi,

I need a formula to help on the following:

I have this range of numbers: 43, 50, 57, 66, 76, 87

And if I entered 43 in a cell and 76 in another cell, I need a 3rd
cell to tell me that the distance is 4 steps!

Thanks in advance.

Khaledity

Assuming your range of numbers is entered in a range of contiguous cells:

=MATCH(Number2,RangeOfNumbers,0)-MATCH(Number1,RangeOfNumbers,0)

This will given an error if Number 1 or Number 2 do not match exactly one of the values in your Range Of Numbers. If you require different behavior, you will need to let us know.