Challenge #410: Optimizing Winter Sports Inventory

[lukas_olsovsky]

It took me a while to get the data cleaned and sorted, thanks for the challenge!!

Running time: 0,3sec

Spoiler

[AGilbert]

Multi-row running total on text in 'Product ID' to build groupings for cross-tab/transpose pairs.

Had to re-lookup how to deal with serial dates. 

Spoiler

[Erin]

Wow I went a totally different route to line this stuff up, but still got the same answer! The route I took might be for the more visual thinkers vs fancy formula parsers...

[AaronSmatta]

With Macro

[adamweaver39]

Spoiler

[vicakram]

My solution

[vicakram]

Spoiler

[Bobbyt23]

Absolutely loads going on in this one, great challenge. Had to look at the solution for help to get started.

[youchun]

Interesting challenge!

[fesrimo]

The Weekly Challenge was very intereting, took me around 16 hours to complete them from 410 to 418.

My solutions for challenge Weekly #410