count number of rows between identical values

[fost_ochelarist]

Hello all,
I'm new around here and have only basic skills with excel.
I have encountered some issues trying to solve a problem.
I will give you an example to be better understood:
71 72 53 76 45 73 75 21 49
34 29 69 73 47 68 17 57 11
4 20 73 53 64 52 68 56 30
36 31 6 62 16 60 34 3 23
73 9 8 27 33 36 48 44 64
57 24 63 29 74 75 16 44 67
50 8 18 14 77 56 54 66 12
74 79 15 60 64 29 39 17 43
15 57 41 74 47 61 58 21 7
29 27 73 71 1 53 22 42 64
33 24 31 29 43 39 58 6 61
56 7 71 49 31 69 70 2 74
21 23 80 49 51 7 12 48 45
67 76 7 9 20 62 70 53 80
35 24 50 51 13 76 45 29 68
36 75 38 22 51 16 39 35 37
9 20 30 8 72 24 63 68 3


I have these values, and want to count the number of rows between 2 identical values. But i want the largest number first, then the second largest and the third largest.
So if in my list of numbers 1 has the largest distance between rows of 10, to get this result, and the second greatest 8 to get this too and again for the third. And also how many times appeared after 10 rows and 8 rows. (ex: 2 times after 10 rows, 5 times after 8..)
Hope that i was clear.
I would appreciate your help!
Thanks!

[FDibbins]

Hi and welcome to the forum

I see that at least 50 members have viewed this thread, and they have all declined to offer any suggestions (myse3lf included) This tells methat you need to either explain in more detail what you want, or narrow down your expectation.

I would also suggest you include a sample workbook, with examples of your expected outcome, and how you arrived at that.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[fost_ochelarist]

Probably I ask too much.. Some hints at least. What formula I have to use to get the row spacing between identical values?