Challenge #19: Excel Record Locator

[karenschuele]

As a rookie, this was challenging!  Used the Tile tool for the first time....my solution not nearly as elegant as the posted solution, but it works.

[euginalim]

Used a Running Total tool instead of Multi-Row Formula - just getting creative! 

[Asal]

I solved it through a complicated process!

My answer is different and I used the two different inputs ,I don't have to the input of others that solve it but my answer is match with the value inside this rows and columns  according to these two sheets.

I confused !

[ganeshnaicker]

Could have done with less tool

[DataG8]

I missed the simple approach options. Need more practice.

Spoiler

[mcultrera]

I came up with the same multi row function as solution.  Got a bit clunkier after that as I didn't think to use the summarize tool.  Although my method will work with text values as well as number values.

[Vidya26]

My Solution

[bnelly1987]

I have to disagree with the level of difficulty given. Took me a bit to get to the answer. Maybe I'm overthinking it.

Spoiler