Very cool! Learning how to do this makes it easier to understand/use/apply the functions to other projects. Thank you :)
@PerezerepL Жыл бұрын
Nice! I was looking for something else and your video came up. I enjoyed it. Thanks so much.
@OfficeNewb Жыл бұрын
Glad you enjoyed it!
@alexdeean3 ай бұрын
Thanks! You helped me with my student project :D
@anniest-pierre63282 жыл бұрын
This is so awesome! thank you!
@GirishMalur Жыл бұрын
Wonderful, Thanks for the awesome exercise.
@OfficeNewb Жыл бұрын
Glad you enjoyed it!
@tyronesingletary91952 жыл бұрын
I will use it at work at our next party
@OfficeNewb2 жыл бұрын
You'll be the hit of the party. :)
@MathiKrishnan2 жыл бұрын
Hello Kyle, Thanks for the interesting exercise. Need a help in my case, I am getting value error ( Excel 2016 ) while using the formula as you mentioned. But it works in the below method. =IF(CONCATENATE(puzzle!O6,puzzle!O7,puzzle!O8,puzzle!O9,puzzle!O10,puzzle!O11,puzzle!O12,puzzle!O13)=B1,1,0) Am I missing something? Thanks, Mathi Krishnan
@OfficeNewb2 жыл бұрын
Hello Mathi - What is the error you are getting? =IF(CONCATE(puzzle!O6:O13)=B1, 1, 0)
@abudhabi44012 жыл бұрын
Excellent, BUT how do I have the crossword without the answers for others to use?
@hamidelbouabidi583 Жыл бұрын
please how can make the completed version looks like yours because in my case it still shows 2 worksheets
@OfficeNewb Жыл бұрын
You can always click on the link in the description of this video and download the completed version so maybe see what you need to do.
@ctreeves082 жыл бұрын
@OfficeNewb.com, this is awesome, thank you! For anyone looking to advance their office skills, I highly recommend Kyle. I've taken all his courses and loved them.
@OfficeNewb2 жыл бұрын
Hello Cliff - Thank you for the shoutout. I'm happy to hear you are enjoying the courses.