Challenge #266: Mother's Day Bouquet

[FilipR]

This one was harder than expected! But it was fun nevertheless.

[lynnesonneyrsm]

overthinker x10

I knew it was iterative but somehow complicated the loop - got there in the end

[Bobbyt23]

Really great challenge, clever macro in this one mixed with practising spatial and report tools.

[westlakecjw]

Spoiler

Solved with a macro:

Spoiler

[Deborah_Simmonds]

Great EMEA session by @FilipR Unfortunately version 2023.2.1.7 restricts Find Nearest to only 20 points maximum...so this is what my solution shows.

[Leyla7777]

Thanks to @FilipR, well explained with macros!

[Bren_Spill]

Spoiler

Workflow: 

Macro:

Output: