Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #189: Billboard Top 100

aihnen
8 - Asteroid

Solution attached.

 

Spoiler
aihnen_0-1573584498947.png
LiD
8 - Asteroid
Spoiler
LiD_4-1573587613138.png

Actually, there are two potential aspects in relation to the field [Artist] which may be considered and in each case or combined will deliver different results:

  1. entries in the field [Artist] with "featuring", in which case the song should actually also count for the specific artist. The relevant workflow with this consideration would deliver different results.
  2. entries in the field [Artist] with " and ". However, this case is more difficult and the relevant solution is not approached, as it cannot be precisely determined whether "and" belongs to the genuine artist name or is it indeed an operator concatenating two artists.

Anyway, the true solution may be little more difficult than it is suggested in the Outputs.

 

Just a compare between the results with (as in the outputs of the challenge) and without cleaning the "featuring" aspect only:

 

Top 100

LiD_6-1573587744482.png

 

Top 10

LiD_5-1573587727049.png

hbraunius
8 - Asteroid

My solution attached.

markcurry
12 - Quasar
Spoiler
solution.png

Snare
8 - Asteroid

This was a fun one. Used a nested if statement for the decades, but now see there's an easier way. Solution below:

Spoiler
Snare_0-1573597365448.png
Adam_Dooley
8 - Asteroid

Done

lmorrell
11 - Bolide

I'm not sure if I'm more satisfied with the succinctness of the challenge, or the results - I guess I'll just have to go with both! 

Spoiler
1.png

 

NoraW
7 - Meteor
Spoiler
Challenge 189_NW.PNG

MarwaBEN
6 - Meteoroid
 
pasccout
8 - Asteroid

Here is my solution...

 

Perhaps a macro would have helped to not repeat the solution...