Snasui Excel Forum

Hi dear
I want result 1/1... 1/20,2/1...2/20 for the same kode but if different code it should start 1/1 ...1/20,2/1..2/20....etc

B5:B44 it is ok but B45 it should like C45 down...

I also attached file

The example formula is below:

=MOD(INT((ROWS(B$5:B5)-1)/20),2)+1&"/"&MOD((ROWS(B$5:B5)-1),20)+1

Enter and copy down.

Thanks