[TABLE="width: 222"]
<tbody>[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]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]10599[/TD]
[TD]5[/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]
</tbody>[/TABLE]
Hi Mr Excel. Past Occurrences. Sample: Columns A1 through G1. Column D rows are numbered in reverse, 1 to current 10608. Hoping to create a formula to number the columns, E, F, and G that correspond with columns A,B and C.
Example: A1 cell is 5. Counting down to row A4 the cell is 5. Basically I'm counting down 3,3 5. Ignore the duplicate 3,
count 1-2. The corresponding column, E1 cell is numbered 2. Sample two: A2 cell is 3 and the cell below that A3 is 3. In the corresponding column, E2 the cell its numbered 1. Another example; A7 cell is 4. Corresponding column E7 cell is 5. Count down from A7: 4,3,5,1,2,4. Thank you. CMLET.
<tbody>[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]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]10599[/TD]
[TD]5[/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]
</tbody>[/TABLE]
Hi Mr Excel. Past Occurrences. Sample: Columns A1 through G1. Column D rows are numbered in reverse, 1 to current 10608. Hoping to create a formula to number the columns, E, F, and G that correspond with columns A,B and C.
Example: A1 cell is 5. Counting down to row A4 the cell is 5. Basically I'm counting down 3,3 5. Ignore the duplicate 3,
count 1-2. The corresponding column, E1 cell is numbered 2. Sample two: A2 cell is 3 and the cell below that A3 is 3. In the corresponding column, E2 the cell its numbered 1. Another example; A7 cell is 4. Corresponding column E7 cell is 5. Count down from A7: 4,3,5,1,2,4. Thank you. CMLET.