At first, I got very different results. At first I was doing multi-rows to separate featured artists so they would get counted as well. That is my lower workflow.
Example: Mariah Carey featuring Boyz II Men gave a count to Mariah Carey and Boyz II Men.
Apparently, that was not the assignment. So I basically duplicated my lower workflow but took out the "featuring" parts and trimmed them off so only one artist could be counted.
However, I don't believe either are fully complete as there are a bunch of artist duos like Diana Ross and Marvin Gaye that also have hits as singles artists, and I could not possibly go through each row to ensure I split them out correctly and give both of the artists their fair share. I believe this is also an issue with Bob Seger as he was listed as Bob Seger, but also as Bob Seger and the Silver Bullet Band. Do I think that create incorrect answers? Possibly. Any duets by singular artists would increase their number. While I believe the artists themselves may be correct, I doubt that their number of top 10 - and especially top 100 - are correct.
