Number of times a number is shown
 

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.

pls don't multipost

--
Don Guillett
SalesAid Software

"David" wrote in message
...
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.

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.

"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 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.

Try the response given at your later post
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----