How to do it in excel
M Madhurima New Member Feb 21, 2018 #1 How to do it in excel Attachments seating.xlsx 8.1 KB · Views: 7
B bosco_yip Excel Ninja Feb 21, 2018 #2 Try, In A1, enter formula copied across to D1 and all copied down to row 7 : =4649474+COLUMNS($A:A)*7+ROWS($1:1)-8 Regards Bosco Attachments seating plan(1).xlsx 10.2 KB · Views: 14
Try, In A1, enter formula copied across to D1 and all copied down to row 7 : =4649474+COLUMNS($A:A)*7+ROWS($1:1)-8 Regards Bosco