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