Forum Discussion

Ian Tobin's avatar
Ian Tobin
Copper Contributor
Jun 20, 2017

Create one list of names combining three lists

Hi I am sure I have done this before but I can't find it now.  I have a spreadsheet with three lists.  I want to combine the lists into one.  On the sheet attached I have three columns of names A, B...
Formulas & Functions
tips and tricks
Patrick_210's avatar
Patrick_210
Copper Contributor
Feb 17, 2019

Sergei I saw your script in the post above and was wondering if you could help derive a script that has been perplexing me for days now. I am trying to create teams for an upcoming function in my school district and need to set teams by two criteria a random number that has been assigned as a student ID and then make sure that a team doesn't have more than two team members from the same school. I need a script because the day of the event we will have students missing due to absence and will need to quickly rearrange the teams. I have excel 2010 and can access 2013. 

Patrick_210's avatar
Patrick_210
Copper Contributor
Feb 17, 2019

=IF

(

H4="Bernal ms",Neff!C6,

IF(H4="Neff MS",Connally!C6,

IF(H4="Connally Ms",Jefferson!C6,

IF(H4="Jefferson Ms",Jordan!C6,0)

)))

 

The function above allows me to pull students from lists in the tabs across the bottom of the spreadsheet ensuring the function changes schools each time, but the problems is making sure I pull form the top of the directed lists each time the formula returns a hit for a school. I am not familiar enough with how to write a script using the "index feature. Making the index function pull from a list until the list is exhausted.