K Kenshin Member Jun 18, 2017 #1 Hello guys it is nice see you again, i have a problem and need a hand here, please see the attach file thank you Attachments Assign Shift.xlsx Assign Shift.xlsx 11.3 KB · Views: 3
Hello guys it is nice see you again, i have a problem and need a hand here, please see the attach file thank you
B bosco_yip Excel Ninja Jun 18, 2017 #3 See attached file with helper formula way. Press F9 for re-calculation. Regards Bosco Attachments Assign Shift.xlsx Assign Shift.xlsx 14 KB · Views: 8 Last edited: Jun 18, 2017
K Kenshin Member Jun 19, 2017 #4 Thanks Bosco appreciate, but how if i add up some more tables, i try the formula but no luck thank you Attachments Assign Shift.xlsx Assign Shift.xlsx 14.7 KB · Views: 3
Thanks Bosco appreciate, but how if i add up some more tables, i try the formula but no luck thank you
B bosco_yip Excel Ninja Jun 20, 2017 #5 Kenshin said: Thanks Bosco appreciate, but how if i add up some more tables, i try the formula but no luck thank you Click to expand... 1] Try to setup a 6 x 25 random number list for 6 tables and define names. 2] See attached file Regards Bosco Attachments Assign Shift(a).xlsx Assign Shift(a).xlsx 19.5 KB · Views: 6
Kenshin said: Thanks Bosco appreciate, but how if i add up some more tables, i try the formula but no luck thank you Click to expand... 1] Try to setup a 6 x 25 random number list for 6 tables and define names. 2] See attached file Regards Bosco
K Kenshin Member Jun 21, 2017 #6 Thank you Bosco, I'm humbled of your knowledge sir.... regards Kenshin
