Challenge #19: Excel Record Locator

[BrianJohnson]

Thank you

[Volha]

Spoiler

 

[Krzysiek]

MySolution

I deliberately dropped headers from xls spreadsheets as it makes more sense to me not to store them in analysis.

To achieve the same result as in the author's solution it would required to adjust formula for rows selection from 2 & 8 to 1 & 7 respectively.

I kept 2&8 as in the original exercise description, hence results are slightly different. but this solution works better for me,

[christopher_ontkean]

Solution.

[LiamHearns]

LiamSolution019

1. Input file pulling in all values from Sheet1 c2

2. Input file pulling in all values from Sheet1 b8

3. Join

[pmag]

Spoiler

[Manoj_k]

19/300

i have created small small macros to achieve the output.

[gjjadhao]

Spoiler

Solution is attached !!!

[whitefang742]

For reference