Excel Challenge 24: Extract Unique Values From a Dataset

This month we’re looking for unique values in an Excel data set, and we’re doing it with a twist.

To get started,

1. Watch the challenge video. 
2. Download the Excel worksheet. 
3. Complete the challenge tasks.
4. Share your solution, discuss it, or ask for help in our Slack channel.

The challenge 🧠

The tasks 🏋️

1. Extract the list of countries that have hosted an Olympic game only once, and from that list:
2. Return the name of the host city.
3. Return the year in which the games were held.
4. Indicate whether the games were held in Summer or Winter.

The clues 🕵️

Can you use the UNIQUE and XLOOKUP functions to your advantage for this Excel challenge? 

		Read - How to Count Unique Values in Excel with the UNIQUE Function
		Read - XLOOKUP in Excel: A Beginner's Guide

Tell us how you would solve it, then check out our solution below!

The solution 💡

We hope you enjoyed taking part in this challenge!

Hungry for more? 🍔

Can't get enough Excel? 😃 We recommend:

1. Trying our previous challenges to sharpen your other Excel skills. 🤹
2. Subscribing to our YouTube Channel 💻 so you never miss another tutorial or future challenge.
3. Joining the GoSkills Slack community 👪 to connect and chat with other Excel nerds.

And check out our expert-led Basic to Advanced Excel course, where you can get certified at your own pace!