hai guys i need help for my assignment for excel function, i have no idea which
ID: 3624344 • Letter: H
Question
hai guys
i need help for my assignment for excel function, i have no idea which function i should use
I will put on life saver if ur answer can help me thanks
so basically, the questions which im confused, are
28 "In the below, name define cell B51 as ""rank_in"" to accept a user input of a World-Wide Rank #.
The adjacent cell (C51) returns the information associated with the rank # from the TopChartTitles sheet.
The resulting string is a concatenation including the corresponding song title, the artist, combined weeks total in the US and the UK, and the year.
The formula should also ensure that a valid input value is within the bounds of however many entries there are in the TopChartTitles table,( i.e., not necessarily 100), otherwise, the prompt ""Out of Bounds!"" is returned.
Implement the solution."
Rank #: Description
2nd question is
29 "In the below, name define cell C60 as ""artist_in"" to accept a user input of an artist's name.
For cell C61, construct the formula that returns the specified artist's World-Wide Rank #
from the TopChartTitles sheet.
"
Artist:
Rank
Here is the data
Thanks all
(World-Wide) Artist Song Title Year US UK Weeks_Total 1 Gnarls Barkley Crazy 2006 29 18 47 2 Shaggy Angel 2001 28 16 44 3 Shakespear's Sister Stay 1992 20 16 36 4 Mariah Carey Without You 1994 23 14 37 5 Jennifer Rush The Power of Love 1985 13 40 53 6 The Righteous Brothers Unchained Melody 1965 13 12 25 7 Bon Jovi Always 1994 32 19 51 8 Bon Jovi It's My Life 2000 20 13 33 9 F R David Words 1982 9 13 22 10 Bryan Adams Heaven 1985 19 5 24 11 Shocking Blue Venus 1970 14 11 25 12 Whitney Houston I Will Always Love You 1992 26 29 55 13 Cher Believe 1998 31 28 59 14 Frankie Laine I Believe 1953 23 36 59 15 Justin Timberlake My Love 2006 29 19 48 16 Kris Kross Jump 1992 21 8 29 17 Crazy World of Arthur Brown Fire 1968 13 14 27 18 The Fugees Killing Me Softly With His Song 1996 17 20 37 19 David Bowie Let's Dance 1983 20 16 36 20 Annie Lennox Why? 1992 20 8 28 21 U2 One 1992 31 6 37 22 Kool & The Gang Cherish 1985 25 22 47 23 Ben E King Stand By Me 1961 14 7 21 24 The Beatles Let it Be 1970 14 11 25 25 Del Shannon Runaway 1961 17 22 39 26 Band Aid Do They Know It's Christmas? 1984 8 32 40 27 Bee Gees Stayin' Alive 1978 26 18 44 28 Wilson Phillips Hold On 1990 25 12 37 29 Savage Garden I Want You 1997 33 7 40 30 Christina Aguilera, Lil' Kim, Mya & Pink Lady Marmalade (Voulez-Vous Coucher Aver Moi Ce Soir?) 2001 20 16 36 31 The Beatles Hey Jude 1968 19 25 44 32 Wham! Freedom 1984 18 14 32 33 Don McLean American Pie 1972 19 16 35 34 Enrique Iglesias Hero 2001 34 23 57 35 Madonna Music 2000 24 23 47 36 Blondie Call Me 1980 25 13 38 37 Kelly Clarkson Because of You 2006 37 25 62 38 New Kids On The Block Tonight 1990 12 10 22 39 Jamelia Superstar 2004
20 20 40 Ten Sharp You 1992
13 13 41 Bing Crosby I Love You 1944 19
19 42 Bee Gees How Deep is Your Love? 1977 32 15 47 43 Spice Girls Mama 1997
15 15 44 The Prodigy Breathe 1996
18 18 45 The Jackson 5 I'll Be There 1970 16 18 34 46 Kylie Minogue The Loco-Motion 1988 27 11 38 47 Bryan Adams (Everything I Do) I Do it For You 1991 22 25 47 48 Lily Allen Smile 2006 16 24 40 49 Crazy Town Butterfly 2001 23 13 36 50 Whigfield Saturday Night 1994
18 18 51 Heart Alone 1987 21 18 39 52 John Lennon Woman 1981 20 11 31 53 Sinead O'Connor Nothing Compares 2 U 1990 21 15 36 54 The Beach Boys Good Vibrations 1966 14 13 27 55 Queen Bohemian Rhapsody 1976 17 17 34 56 John Lennon Imagine 1971 9
9 57 Madonna Like a Prayer 1989 16 13 29 58 Sara Bareilles Love Song 2008 41
41 59 Celine Dion My Heart Will Go On 1998 20 21 41 60 Diana Ross Upside Down 1980 28 12 40 61 Avril Lavigne Girlfriend 2007 24 27 51 62 Bobby Goldsboro Honey 1968 15 15 30 63 Barbra Streisand A Woman in Love 1980 23 16 39 64 Procol Harum A Whiter Shade of Pale 1967 12 15 27 65 Fleetwood Mac Dreams 1977 19 9 28 66 Mariah Carey Someday 1991 19 5 24 67 Pink Floyd Another Brick in the Wall (part 2) 1980 25 12 37 68 The Black Eyed Peas Where is the Love? 2003 25 19 44 69 The Monkees I'm a Believer 1967 15 17 32 70 The Animals House of the Rising Sun 1964 11 12 23 71 U2 Desire 1988 17 13 30 72 Laura Branigan Gloria 1982 35
35 73 Bing Crosby White Christmas 1942 6
6 74 DJ Jazzy Jeff & The Fresh Prince Summertime 1991
12 12 75 Wet Wet Wet Love is All Around 1994 20 37 57 76 Lipps Inc Funkytown 1980 23 13 36 77 Des'ree Life 1998
15 15 78 John Travolta & Olivia Newton-John You're the One That I Want 1978 24 26 50 79 KC & The Sunshine Band Please Don't Go 1979 25 12 37 80 Bee Gees Tragedy 1979 20 10 30 81 Abba Dancing Queen 1976 21 20 41 82 Akon Lonely 2005 20 16 36 83 Mariah Carey Fantasy 1995 25 11 36 84 Tears For Fears Shout 1985 19 20 39 85 Michael Jackson Billie Jean 1983 24 18 42 86 Irene Cara Flashdance... What a Feeling 1983 25 14 39 87 Phil Collins Another Day in Paradise 1989 17
17 88 The Human League Don't You Want Me 1982 28 13 41 89 Chris Brown Forever 2008 33 27 60 90 A-Ha Take On Me 1985 26 19 45 91 Ultra Nate Free 1997 19 17 36 92 Los Lobos La Bamba 1987 21 11 32 93 Mungo Jerry In the Summertime 1970 13 20 33 94 Stevie Wonder I Just Called to Say I Love You 1984 25 39 64 95 Irene Cara Fame 1980 26 16 42 96 Johnnie Ray Cry 1951 27
27 97 Britney Spears Sometimes 1999 20 16 36 98 Elvis Presley Surrender 1961 12 15 27 99 The Village People YMCA 1979 25 16 41 100 Aswad Shine 1994 14
14
Explanation / Answer
First part:
=IF(COUNT(TopChartTitles!A:A)<rank_in,"Out of Bounds!",CONCATENATE(VLOOKUP(rank_in,TopChartTitles!A:G,3)," - ",VLOOKUP(rank_in,TopChartTitles!A:G,2)," - ",VLOOKUP(rank_in,TopChartTitles!A:G,7)," - ",VLOOKUP(rank_in,TopChartTitles!A:G,4)))
Second Part:
=INDEX(TopChartTitles!A:A,MATCH(artist_in,TopChartTitles!B:B,0))
Note -- I'm assuming that the data is contained in columns A through G of a sheet named TopChartTitles.
Out of Bounds!Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.