I am having troubles with Tasks 2 and 3. I signed up to see the answers and now I see they only got them for Task 1 which I was able to figure out. Could you post solutions for the next few tasks? It would be a huge help for me. The Programming language is Visual Basics for applications on excel.

Thanks,

Phil

Here is the original post with all tasks.

Here is the information given on an excel doc:

Title	Production Cost (in millions)	Box Office (in millions)	#Rentals	Genre
The Sound of Music	10	324	5	Musical
Batman Vs Superman	35	88	10	Action
Ocean's Eleven	10	62	9	Comedy
The Great Debaters	11	491	2	Drama
Sully	37	951	2	Drama
Lord of the Rings: Two Towers	37	768	1	Drama
Armageddon	19	852	8	Action
Mr and Mrs Smith	98	62	1	Action
My Fair Lady	38	204	5	Musical
Chicago	69	992	20	Musical
Revolutionary Road	38	423	11	Drama
No Reservations	27	412	2	Drama
Gone in Sixty Seconds	89	998	10	Action
The Lion King	82	384	1	Musical
Lord of the Rings: Return of the King	41	314	11	Drama
Man of Steel	79	57	3	Action
Matrix	26	827	11	Action
Titanic	35	805	8	Drama
Forest Gump	4	55	4	Drama
Catch Me If You Can	73	499	1	Drama
Dreamgirls	70	933	7	Musical

Tasks Task 1: Helper functions The first functions that you will create are helper functions that can be used by other functions. Function FindMax (valueArray, nameArray) As String This function takes in two arrays; the first array has the numeric values while the second array has the names. The function will find the value in the first array that is the largest and return the corresponding name (from the second array). For instance, if the valueArray = (10, 20, 5, 9) and nameArray is ("House", "Chair", Table", "Book"). The function will return Chair. Function FindMaxRange (valueRng As Range, nameRng As Range) As String Similar to the FindMax function, the only difference is that the input values are ranges. Function printMovieData(title As String, arrayTopic, arrayother) This function prints out information about the movies to the Immediate Window. For instance, if the title is "Movie by Genre", array-Topic ("Horror", "Comedy", "Action") and arrayOther is (5, 6, 1). The output to the Immediate Window will be: Horror 5 Comedy: 6 Action : 1 2 of 4