I need the sequence in the second column to have the same value if the cell total in the first column is the same, there can be multiple totals the same. The sequence also needs to continue after the same number is accounted for.
I do not know where to start. I have sequenced the second column but do not know where to go from here.
Example
74 1
71 2
70 3
70 3
70 3
67 6
65 7
65 7
61 9
| Col A | Col B |
|---|---|
| 74 | 1 |
| 71 | 2 |
| 70 | 3 |
| 70 | 3 |
| 70 | 3 |
| 67 | 6 |
| 65 | 7 |
| 65 | 7 |
| 61 | 9 |
1
If it will always be the case that, as in your example, your data is sorted descending, then you can simply use the RANK.EQ function:
P1: =RANK.EQ(O1:O9,O1:O9)
2
If I understood the question correctly, then sort data in your column A, add a starting number in B1, and apply the following formula in cell B2
=IF(A2=A1; B1; MAX($B$1:B1) + 1)
corrected fomula for O and P:
=IF(O1=O2; P1; P1 +COUNTIF($O$1:O1; O1))
Excel view
5