Please create a Pivot Table using the data below to find thetotal number of weeks each artist maintained a #1 album. Input theanswers in the yellow highlighted area. Place the pivot table onB13 of this tab.
Can I have the Excel formula? how to getit?
ArtistWeeks at #1Week ofAlbumArtistPhil Collins1/6/1990…But SeriouslyPhilCollinsMilli Vanilli1/13/1990Girl You Know It’s TrueMilliVanilliPaula Abdul1/20/1990…But SeriouslyPhilCollinsThe Beatles1/27/1990…But SeriouslyPhilCollinsBeastie Boys2/3/1990Forever Your GirlPaulaAbdul2/10/1990Forever Your GirlPaulaAbdul2/17/1990Forever Your GirlPaulaAbdul2/24/1990Forever Your GirlPaulaAbdul3/3/1990Forever Your GirlPaulaAbdul3/10/1990Forever Your GirlPaulaAbdul3/17/1990Forever Your GirlPaulaAbdul
Expert Answer
An answer will be send to you shortly. . . . .