Microsoft Excel

2 minute read

Excel Challenge 24

Claudia Buckley

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. 
  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.

Spreadsheet with data

The clues 🕵️

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

 Excel image    

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?

Start learning for free with GoSkills courses

Start free trial

Join the Excel conversation on Slack

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

Claudia Buckley

Claudia Buckley

Claudia is a project manager and business skills instructor at GoSkills. In her spare time, she reads mystery novels and does genealogy research.