Mod function with row and column

prince
2StarLounger
Posts: 171
Joined: 02 Mar 2015, 17:00

Mod function with row and column

Post by prince »

Dear Sir/Madam, I want to prepare a seating plan (Sheet 3) for 18 students per page(each page includes 14 rows). But the mod function is not working. Kindly help to solve the problem.
Thanks & regards
Prince
You do not have the required permissions to view the files attached to this post.

Toranaga
3StarLounger
Posts: 254
Joined: 15 Aug 2016, 11:23

Re: Mod function with row and column

Post by Toranaga »

Do not use merged cells!!!!

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Mod function with row and column

Post by HansV »

Here you go again:

10th & +2 Seating plan.xlsm
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

prince
2StarLounger
Posts: 171
Joined: 02 Mar 2015, 17:00

Re: Mod function with row and column

Post by prince »

Thank you sir, It's working perfectly.
Thank you so much
with regards
Prince