Excel can do it! Past Occurrence.

[CMLET]

[TABLE="width: 222"]
<colgroup><col span="3"><col><col span="3"></colgroup><tbody>[TR]
[TD]3[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]10609[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]5[/TD]
[TD]2[/TD]
[TD]10608[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]10607[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]10606[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]5[/TD]
[TD]2[/TD]
[TD]10605[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]10604[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]10603[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]10602[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]10601[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]10600[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]10599[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]10598[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]10597[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]10596[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]5[/TD]
[TD]1[/TD]
[TD]10595[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]5[/TD]
[TD]2[/TD]
[TD]10594[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]10593[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]10592[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]3[/TD]
[TD]5[/TD]
[TD]10591[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]10590[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]10589[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]10588[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]

Columns A,B and C cell data contain numbers, (1,2,3,4,5) Counting rows between identical numbers. A11 cell data is (1).
A22 cell data is (1). the rows separating the (1's) are 10. The numbers separating between A11 and A22 are, (2,4,5) omitting duplicate numbers. The E11 column cell data is posted (4) Counting downward from A11 to the previous (1) omitting duplicates equals 4. "Changing the Logic." Applying this methodology to the columns E, F and G will contain cell data numbered in: (1,2,3,4,5).

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1065294-excel-can-do-past-occurrence.html#post5116038

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).