In this tutorial we’ll look at how to randomly pair two teams from a list of 10, five from each of two countries, but with the condition that we can’t pair two teams from the same country. We’ll use IF, RANDBETWEEN, and CHOOSE functions to accomplish this. Here we go!
Tag Archives | CHOOSE
Here is one method to sum up a variety of columns based on dymanic data validation lists and using SUMIFS, CHOOSE, and MATCH functions…..
Here is how you can use VLOOKUP to look for values to the left instead of the right…..
Here are three examples of the use of Excel’s CHOOSE function: You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner. Take a few minutes (5:02 to be exact!) and watch the video to learn about using the CHOOSE function. […]