Webucator Blog Use Excel 365 to create a Sorting Hat and House Point Scoreboard

Here’s the challenge: you are going to randomly assign each of 20 new students to one of the four houses. You will then populate a (between -100 and 100) to a random student. You will show both the student name and house on the scoreboard. And then you will show a list of unique students who scored points. In our solution, we use the INDEX, RANDBETWEEN, ROWS, XLOOKUP, and UNIQUE functions.