vba excel

peaceandlove101

New Member
Joined
Mar 5, 2017
Messages
1
· Function MovieWithLargestRental(rngMovie As Range,
rngMovieRental As Range) As String
This function finds and returns the movie with the largest number of rentals.
There are two input parameters, the first is a range from the worksheet that has
the name of the movies, while the second is a range from the worksheet that has
the number of times each movie has been rented.
· Function MostExpensiveMovieToMake(rngMovie As Range,
rngMovieProduction As Range) As String
This function returns the most expensive movie to make. The first parameter is a
range of the names of the movies, the second parameter is the range of
production costs.
he worksheet that has
the number of times each movie has been rented.
pleaaaaseee help thank you in advance
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Welcome to the Board!

I think that you will find people don't typically like to do people's homework or assignments for them. However, we are willing to help point you in the right direction.
Why don't you post what you have done on it so far, and perhaps we can give you some hints?
 
Upvote 0

Forum statistics

Threads
1,214,943
Messages
6,122,380
Members
449,080
Latest member
Armadillos

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top