This is a follow up to help that I received a while ago on a similar question.
I have a list of students that need to sorted into teams of three persons. (see attachment - 'SHUFFLE' worksheet)
Absent students - i.e. students signified by a number (see worksheet) rather than a name need to be excluded from the sort.
I tried to do this myself by manipulating the formula I had for making pairs but got stuck pretty quickly.
Can anyone help with this.
Hi nhush,
I believe you need the formula in the range I3:k16... but I am not getting the logic.. can you enter some results manually and provide some explanation for them ? thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
Hi nhush!
I think I have solved your problem.
Don't forget to click on the little star to the left of this post if you feel I helped!
Taming the Excel dragon... www.TheExcelphile.com
thanks - it worked a treat! I'll keep looking for the 'star'.
... I've found it!
Great work TheExcelphile,
will click on the star for sure.
Thanks Mihir!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks