Hi is this for an assignment? Do you have to do it the way specified? I ask because this can be done using the max function in combo with INDEX/MATCH as a lookup.
Roselyn B.
asked • 03/27/21Having issue with Excel 2019
In cell N5, enter an INDEX FUNCTION that will retrieve the name of the movie with the highest gross sales, Write the function as the array argument.
Follow
•
2
Add comment
More
Report
2 Answers By Expert Tutors
Edward A. answered • 03/28/21
Tutor
4.9
(17)
Math Tutor, Retired Computer Scientist and Technical Communicator
Roselyn, I can’t see the excel table, or at least the header rows. Then we can help.
Still looking for help? Get the right answer, fast.
Ask a question for free
Get a free answer to a quick problem.
Most questions answered within 4 hours.
OR
Find an Online Tutor Now
Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.
