# Excel Challenge 24: Extract Unique Values From a Dataset

Claudia Buckley

#### Join the Excel conversation on Slack

Ask a question or join the conversation regarding Excel challenges on our Slack channel.

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

Get the challenge file!

Start working on the Excel challenge with this workbook.

To get started,

1. Watch the challenge video.
4. Share your solution, discuss it, or ask for help in our Slack channel.

## The challenge 🧠

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

Get the challenge file!

Start working on the Excel challenge with this workbook.

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!

Ready to become a certified Excel ninja?