Offset

L

Legacy 54229

Guest
I have a sheet that containts titles of movies in column A and runtime in column N (other information fills the other columns). How would I format a formula to locate the largest runtime and return the title of that movie? (Column A contains the movie titles in alphabetical order and column N contains the runtime for the movie in that row.)
Thanks!
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
hi - welcome to the board!

something like:

=INDEX(A1:A25,MATCH(MAX(N1:N25),N1:N25,0))

...though you'll just get whatever turns up first is there's more than one item with the max value.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,084
Messages
5,570,129
Members
412,305
Latest member
Mozz
Top