Offset

[Legacy 54229]

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!

 

[PaddyD]

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.