number of spaces between numbers
 

I am wondering if there is a formula to show how often a number is listed.

ie. List 1, 2, 3, 4, 5, 2, 4, 3, 1, 1, 5, 2, 3

This would show
1: 8, 1
2: 4, 6
3: 5, 5
4: 3
5: 6

in other words show the space between when the number showed and the next
time it showed.

Thank you.

I could even create a formula to show what row the number was
found.

ie.
Row Number
----- ---------
100 1
101 2
102 3
103 2
104 3
105 1

Having the results show:
1: 100, 105
2: 101, 103
3: 102, 104

Any help would be appreciated.


"David" wrote:

I am wondering if there is a formula to show how often a number is listed.

ie. List 1, 2, 3, 4, 5, 2, 4, 3, 1, 1, 5, 2, 3

This would show
1: 8, 1
2: 4, 6
3: 5, 5
4: 3
5: 6

in other words show the space between when the number showed and the next
time it showed.

Thank you.