Hello,
I have data in rows
I need a max formula for the last 12 consecutive months.Formula should calculate value more than zero and the calculation should start from right.
Formula result should show For RON its 24 & Jude its 9.
<tbody>
</tbody>
I have data in rows
I need a max formula for the last 12 consecutive months.Formula should calculate value more than zero and the calculation should start from right.
Formula result should show For RON its 24 & Jude its 9.
J | F | M | A | M | J | J | A | S | O | N | D | J | F | M | A | M | J | J | A | S | O | N | D | J | F | M | A | M | J | J | A | S | O | N | D | |
RON | 12 | 2 | 0 | 8 | 0 | 0 | 0 | 0 | 6 | 2 | 3 | 8 | 9 | 4 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 6 | 8 | 9 | 24 | 0 | 0 | 1 | 3 | 6 | 1 | 0 |
JUDE | 0 | 0 | 2 | 5 | 6 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 5 | 8 | 0 | 0 | 9 | 5 | 0 | 0 | 2 | 3 |
<tbody>
</tbody>