Challenge #1: Join to Range

[Cmacp433]

Solution with both the join tool and the find replace tool

[kzrolfes]

Spoiler

[Toons]

This is my answer.

[rajenderk18]

Its very straightforward. Here is how I approach it:

1. First I use the generate row tool and in that I use the left and ToNumber formula on Range column.

2. Then I use the join tool to join both the table.

3. Then I use summarize tool as needed by the question.

5, Finally Browse tool to show the answer.

Spoiler

[OnionKnight]

Lots fun!!

[clmc9601]

My solution

[beccat]

Love going back and working through these!

[AlexHirstData]

Determined to start posting these. Done many but going to start from the front. Sorry, I took the long way round for this one!

[jaialai32]

Here's mine.

[TraceyD]

First one!