Challenge #19: Excel Record Locator

[kri3091]

Spoiler

[cmv]

Spoiler

[Skrupczak]

This one took some trial and error for me to figure out what order to do things in so I didn't end up with extraneous records at the end. I used the tile tool earlier today for the first time based off of seeing it used in someone else's response to a different challenge, and was able to understand how it could be applied here when I was going through this challenge, so the practice and observation of other's approaches is definitely helping me learn tools that are not part of my current use!

Spoiler

[abowers004]

I'm not going to post my solution because I could not figure this one out without viewing the posted solution. This is labeled as beginner and after seeing what was going on it was not very complicated to follow; as a beginner myself though, I would not label it as such. I went through a lot of trial and error to actually see how the operations were actually working.

[The_Rad_Valentina]

This one was interesting. 

[GeraldJTessier]

Here my solution

[AnnaMikhaylova]

For a simple solution, it seems that I ended with over complicated solution, but as long as I got there, and confident enough that my solution is scalable to 100 books. 

Spoiler

[Blake]

I took a little bit different approach than the provided solution but it still works! 

Spoiler

[RNG]

.

[VenkataP]

Here is similar solution using Tile..