Mod function is not working properly in excel

[prince]

Hello sir, I want help to solve the problem of mod function in excel sheet.
I have stored the data in first sheet. But on second sheet Red columns are not showing the accurate result.
kindly find the attached file and suggest me the best way .
Regards,
Prince

[Rudi]

If the formula in the F column (for Sr. No.) is working correctly, why not just use that formula for the Participant Name column too. Just point it to the source sheets's J column instead of the I column?

In G15 use:
=IF(OFFSET(Sheet1!$J$3,INT((ROW()-15)/30)*6+MOD(ROW()-15,30),0)="","",OFFSET(Sheet1!$J$3,INT((ROW()-15)/30)*6+MOD(ROW()-15,30),0))

I have not studied the sheet or tried to evaluate the formula as I don't understand the basis of your form?

[HansV]

Please do not remove an attachment after you have received a reply. That makes the thread incomprehensible to others. If the file contained sensitive information, you should have removed it before posting it.

Apart from that, it would be polite if you let us know whether Rudi's reply was helpful.

[prince]

Mr. HnasV,I have uploaded the file again and thanks to mr. Rudi to suggest me the best way to solve the problem with previous applied method on column.
Regards,
Prince

[HansV]

Thanks, Prince!