Hi,
I would like to place the letter P in a cell if the count of that cell and the preceding cells is less then of equal to the number in a different cell. I would like this to continue down the row until the cell containing the P is the same number as the different cell (see below). I have tried to use an if and countif formula.
thanks for your help
<tbody>
</tbody>
I would like to place the letter P in a cell if the count of that cell and the preceding cells is less then of equal to the number in a different cell. I would like this to continue down the row until the cell containing the P is the same number as the different cell (see below). I have tried to use an if and countif formula.
thanks for your help
TOTAL | 5 |
101 | P |
102 | P |
103 | P |
104 | P |
105 | P |
106 | |
107 | |
108 |
<tbody>
</tbody>