Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #273: Filling In The Blanks

binuacs
20 - Arcturus
Spoiler
binuacs_0-1624460830627.png

 

achillesjing
7 - Meteor

Here is my solution

DataHabanero
9 - Comet

Eazy Peazy Lemmon Squeezzay

Tyro_abc
11 - Bolide

 

Tyro_abc_0-1624479847613.png

 

 

output:

Tyro_abc_1-1624479945161.png

 

Best Regards

Arundhuti

bcronnelly
5 - Atom
Spoiler
Spoiler

bcronnelly_0-1624480420580.png

dennislee
5 - Atom
Spoiler
dennislee_0-1624480745720.png

 

Can you find a shorter solution?

lbarthelemy
6 - Meteoroid
Spoiler
Spoiler
lbarthelemy_0-1624481050115.png
dschlegelmilch
6 - Meteoroid
Spoiler
dschlegelmilch_1-1624481073556.png

 

DalasJ
5 - Atom

Good practice on Row Generator 

KieranAdair
7 - Meteor

Interesting... Looks like I may have a slightly different solution than others. Interesting challenge 🙂

 

Spoiler
Solved using a crosstab/transpose then multirow formula to find previous transactions.

AWC.png