 Hello everyone and welcome to today's short tip video so what we're going to be doing is taking our list of names You see here in column B So we've got a total of what 18 names there and we want to split these not only just into three teams But we want those teams to be randomly generated So if I was to hit f9 now because the form is still in there You can see it's going to continue to update but continuously it's always going to be in a random order So some of the functions I'm sure you're probably already aware of but what we'll do is delete the formula out that we're using at the moment So we can rebuild it starting from scratch So the fundamental part of this formula is going to be using something called wrap rose So if you're not familiar with that rose and if I could spell it correctly All it simply does is allows us to provide a range of rows So like I'm doing here and then after the comma so we've only got two inputs for this We can provide the number of columns we wish for that to be split over so for us we have three teams So I want this row or all these rows split over three columns By closed brackets in it enter you can see how those names have now gone from being just a list of rows Into see three columns however at this point you can see going from left to right It's simply just maintaining that same order as we had in our names list So Serena Keen and Palmer is your first three here Serena Keen and Palmer This may be suitable for you because you could say well, it's not random But you do have obviously a different ordering in terms of team one two and three from top down in our names list But we want this to be is we wanted to be completely Randomly generated so there were no patterns or you know Favouritism based to how someone was appearing in this list So in order to do that we just need to update mainly just this little section here to ensure that everything is being Randomized in order to do that the first part we're going to do is change our range here to sort by and then open our brackets and This is now where we are going to put in our names or a range of names so if I click on Serena down to now at the end there and then What do we want to do or how do we want to sort this range? Well, we want it to be random and lucky for us. There is a function in Excel called random array So if you type in random array And then open brackets We can now all we need to do now is obviously provide How many items there are within our range? So for us, we're going to use now the last function, which is counter so go into count a open brackets and Then lastly or once again, should I say select our range of names like so and Then we just need to do some closed brackets. So a closed bracket here so this is now giving us the total number of values in our array and Then our next closed brackets is obviously closing off our random array So our random array is basically going to pick a at random Eat a value or a number should I say within our total once available? So obviously it's going to continue to randomize that to make sure that everything is again I keep using the word random But it's going to obviously make sure it is random and then last closed brackets is going to close off our Sort by so where previously all of this section here was just a simple basic range selection here nicely highlighted You can see how we've now utilized sort by and random array Fundamentally to make sure that it's going to produce our values in a random order And then just for clarity if you forgot the beginning the three at the end here is simply just defining how many columns We wish for this these rows to then be split over once we're happy with that we'll just Hit enter and you can see how our array has now updated So we obviously had that formula in before so you would have seen some names here But now hopefully you've noticed that they're in a random order So rather than having serene keen and Palmer you can see if we to try and find only Parmas here serene is here and in who is the other one keen so you can see comparing our top-down three here You can see how they're randomly selected with even Palmer being before serene And if we now use F9 you can continue to refresh that formula to further randomize these Three teams if you so need to so I hope you enjoyed that video If you did please don't forget to give the video a like and of course feel free to drop us a comment below If you do have any questions at all if this is the first time watching one of our videos or you've watched in the past And you're still yet to subscribe Could I please ask you to not only hit that subscribe button? But also that bell notification button that way you should be notified of all of our future videos as they come out So thank you very much for watching and we'll see you in the next video