ETL_Case4.xlsx (137.4 KB)
I really enjoyed the contat function. Didn’t realize how quickly we’d be able to integrate our class learning into application
Challenge1_Hello_World.xlsx (56.8 KB)
This was a great challenge. Really grateful to Mark who provided the advice about using the =TEXT function in order to get the correct number of digits in the Name ID. Super helpful tool!
Challenge1_Hello_World_MasonLewis.xlsx (63.7 KB)
1 Like
Challenge1_Hello_World.xlsx (57.0 KB)
This was a really cool exercise!
Challenge1_Hello_World.xlsx (56.3 KB)
Thank you for the opportunity to work on this challenge. I learned a lot! The solution video was so helpful when I got stuck.
Challenge1_Hello_World.xlsx (58.2 KB)
Great Challenge Nate! The pattern was very clever! You should throw together a challenge on subliminal messaging via data trends haha. I initially tried to use a combination of string functions to separate out the text in the VotingData tab, but TEXTSPLIT was definitely the way to go!
1 Like
I had some difficulty getting it to work as well, but I realized that my numbers were stored as text. I was able to manipulate them all into number values using the Text-to-Columns function (thanks ChatGPT), and it worked after that.
Excellent practice of the XLOOKUP function and using concatenation within a function. After viewing the solution video and analyzing the comments, I found the TEXTSPLIT function to be very helpful and much more straightforward than my original process.
1 Like
Challenge1_Hello_World.xlsx (57.1 KB)
Fun ending to a fun challenge! I had never used the Conditional formatting function up till this point. Inside my final Xlookup, I didn’t use the concat function, but rather just basic & symbols.
Challenge1_Hello_World.xlsx (56.2 KB)
Awesome challenge! I learned so many formulas while doing this. It took me quite a long time to figure out but the result was worth-waiting.
ACC407_Techhub_3-Challenge1_Hello_World.xlsx (57.0 KB)
Challenge1_Hello_World.xlsx (58.1 KB)
It’s been a long time since I have concatenated and used the SUMIF functions. This has been a great review!
This was a great challenge to start with! I got to relearn how to use =XLOOKUP and I also learned about how to copy and paste as values so that data won’t get mixed up.
Challenge1_Hello_World.xlsx (57.2 KB)
I totally overlooked the importance of converting the “numbers stored as text” to actual numbers. Once I did so, this was the result…
Challenge1_Hello_World (1).xlsx (57.9 KB)
Ran into some issues with my last-step-formatting not working in excel, but when I exported it to google sheets and then re-imported it to excel it had cleaned up any broken formatting and worked great!
Great Challenge.
