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
Mod function with row and column
-
- 2StarLounger
- Posts: 171
- Joined: 02 Mar 2015, 17:00
Mod function with row and column
You do not have the required permissions to view the files attached to this post.
-
- 3StarLounger
- Posts: 256
- Joined: 15 Aug 2016, 11:23
Re: Mod function with row and column
Do not use merged cells!!!!
-
- Administrator
- Posts: 78625
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Mod function with row and column
Here you go again:
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 171
- Joined: 02 Mar 2015, 17:00
Re: Mod function with row and column
Thank you sir, It's working perfectly.
Thank you so much
with regards
Prince
Thank you so much
with regards
Prince