Number of times a number is shown

[David]

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 number of times between when the number showed and
the next time it showed.

Thank you.


PS - It would be even more help if the numbers are listed down the column.

 

[Don Guillett]

pls don't multipost

 

[David]

Thinking wise 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.

 

[Max]

Try the response given at your later post