Challenge #369: Formula 1 Grand Prix (In)efficiency

[mithily]

Spoiler

wrote a lovely iterative macro all by myself first answer matches exactly and my second answer is slightly less

[gawa]

My solution is smaller than output

[JosephSerpis]

Challenge Completed

Spoiler

[Anmol97]

Here's my solution

[LiuZhang]

[michaelbono16]

Tried to use do as much as possible within multi-row formula tools for efficiency

[tristank]

I love seeing all the different iterative macro approaches. I can't even wrap my head around some of them

Spoiler

[sknman92]

Spoiler

 

 

My solution! Like some have noted below, my answer for number 2 is smaller than the provided answer.

[raeaton]

Spoiler

 

[asultanov]

The issue with the max distance limit in the Find Nearest tool still hasn't been fixed in my version of Alteryx. :(

Spoiler

But maybe that's for the best since it gives the wrong answer...