5 | 5 | 2 | 10608 | 2 | 2 | 2 |
3 | 4 | 5 | 10607 | 1 | 1 | 1 |
3 | 4 | 5 | 10606 | 4 | 2 | 4 |
5 | 5 | 2 | 10605 | 4 | 5 | 3 |
4 | 4 | 3 | 10604 | 2 | 3 | 5 |
1 | 2 | 1 | 10603 | 4 | 5 | 4 |
4 | 1 | 2 | 10602 | 5 | 5 | 3 |
3 | 4 | 5 | 10601 | 5 | 4 | 2 |
5 | 3 | 4 | 10600 | 4 | 3 | 4 |
1 | 5 | 5 | 10599 | 5 | 4 | 1 |
2 | 2 | 5 | 10598 | 2 | 4 | 5 |
4 | 3 | 2 | 10597 | 3 | 1 | 3 |
2 | 3 | 1 | 10596 | 2 | 5 | 1 |
5 | 5 | 1 | 10595 | 2 | 1 | 5 |
2 | 5 | 2 | 10594 | 2 | 5 | 2 |
5 | 4 | 4 | 10593 | 3 | 3 | 5 |
<tbody>
</tbody>
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.