This is so cool! You did such a good job with the conditional formatting. You did a good job following the instructions and being creative!
Just finished the data set and went with some patriotic colors for my name matrix. I had never used the textsplit function before this problem.Thanks for the challange!
JamesJohnsonTechHubExcel1.xlsx (57 KB)
2 Likes
The last step was awesome! It was helpful to practice the Xlookup and Concat functions. Great challenge!
2 Likes
This challenge was so fun! It put a lot of skills into one. My favorite part was picking the fun colors for the matrix.
2 Likes
Great challenge. Text before and text after were beneficial, especially for website names. When creating nested functions “MID” and “SEARCH” together can perform the same function as trying to use a nested before and after (still trying to combine the two. )
It was good to apply some good practical knowledge in this problem. I hadn’t used the “=xlookup(concat(” function before. I still need to practice it more, but it’s helped!
This challenge was very helpful, it made me think and I had to remmebr how to use a lot of the formulas I haven’t used in a while. It was a good refresher on xlookup, sumif, and data parsing tools.
Unlike the solution, I used combinations of the TEXTAFTER() andTEXTBEFORE() functions to parse the data in the Voting_Data Sheet of the excel file.
1 Like
This was a good review of what we had just learned in data analytics class!
Challenge1_Hello_World.xlsx (59.3 KB)
407Challenge1_Hello_World.xlsx (51.7 KB)
Just learned this in class I used text before and text after and flashfill instead of TextSplit. Xlookup and concat weren’t very difficult.
Challenge1_Hello_World.xlsx (36.2 KB)
I thought this was a really great challenge, it helped me a lot to see how to better use the text to column feature as well as other excel function i haven’t had much experience with
1 Like
Challenge1_Hello_World.xlsx (69.2 KB)
Challenge1_Hello_World_Final.xlsx (70.9 KB)
Great challenge! I used TEXTBEFORE and TEXTAFTER for a lot of the data parsing.
Challenge1_Hello_World.xlsx (76.5 KB)
This was a nice refresher of some basic formulas. The coolest part of this challenge and submitting my answer was actually discovering how to hide my solution until it gets clicked on. Quite a nice feature.
Fun way to use some of the functions in Excel!
Challenge1_Hello_World.xlsx (58.5 KB)
Awesome! Here are my solutions
Challenge1_Hello_World.xlsx (93.6 KB)