BYU Student Author: @Benjamin_Lau, @Dallin_Gardner, @Carter_Lee
Estimated Time to Solve: 5 Minutes
We provide the solution to this challenge using:
- Excel
Need a program? Click here.
Overview
You received a dataset from a start-up real estate company based in Utah County. The dataset provided by the real estate startup includes property specifics like city, price, and address. Your goal is to use your magnificent Excel skills to uncover interesting facts about recent transactions.
Prizes
The Top 3 fastest people will win Amazon gift cards – 1st gets $50, 2nd gets $30, and 3rd gets $20. Make sure you upload your solution file and a screenshot of the time on the SWAG 4 post on TechHub.training. Tell the TechHub crew your name and time. (For in-person attendees only)
Instructions
Before you start, make sure to read through the dataset and instructions. Set up the timer as instructed when you are ready.
-
Fill in the CityCode and City columns for each transaction. CityCode is the character before the dash. The table for city names is provided on this sheet.
-
Find the property with the highest price. List the city, price, and address for that property.
Data Files
Suggestions and Hints
- Consider using LEFT, XLOOKUP, and MAX functions
Solution
The solution will be posted after the challenge takes place.
