Hello Sir/Madam, I have prepared a seating plan for 12 students in each room. But in Tab 3 (seating plan) column B7-B10 formula, not applying. It starts working from Column C7-C10. Kindly sort out this problem.
Thanks & Regards
Prince
Required some changes in excel formula.
-
- 2StarLounger
- Posts: 171
- Joined: 02 Mar 2015, 17:00
Required some changes in excel formula.
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78481
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Required some changes in excel formula.
Change the formula in B7 to
=IF(INDEX('Roll-No'!$A$1:$A$2001,12*INT(ROW()/12)+MOD(ROW()-7,4)+4*COLUMN()-6)="","--",INDEX('Roll-No'!$A$1:$A$2001,12*INT(ROW()/12)+MOD(ROW()-7,4)+4*COLUMN()-6))
Fill to the right, then down (or vice versa).
=IF(INDEX('Roll-No'!$A$1:$A$2001,12*INT(ROW()/12)+MOD(ROW()-7,4)+4*COLUMN()-6)="","--",INDEX('Roll-No'!$A$1:$A$2001,12*INT(ROW()/12)+MOD(ROW()-7,4)+4*COLUMN()-6))
Fill to the right, then down (or vice versa).
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 171
- Joined: 02 Mar 2015, 17:00
Re: Required some changes in excel formula.
Thank you sir so much for this support. Really I am grateful for this help.
With regards,
Prince
With regards,
Prince