Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHi @kat
Back with a vengeance, I see. All the missing challenges in 1 day. Good to have you back.
Dan
Took some creativity to figure out how to group various columns together, but finally figured out a formula that would work.
Thought I might be able to use the optimization tool for this but couldn't figure it out. Instead I went with more of a brute force method.
I was trying to see if I could get around parts using the data transposed to try and write more simple formulas, but got my head in a mess.
So looks like I went down the route of many......
Hi,
I chose to recalculate the position on each ring so it directly in the right position before gathering all the rings together via their Position.