Dynamic navigation using hyperlinks - quickly "jump" to Max/Min in Excel
This video shows how to use the hyperlink function to quickly navigate to the Maximum or Minimum value in a range or column.
Link to workbook:
https://docs.google.com/spreadsheets/...
00:00 Introduction
00:37 How to create hyperlinks
01:37 When the hyperlink function does not work
02:20 Making the function work
02:52 The magical # sign used in hyperlinks
03:55 Getting the maximum value in a range
05:35 Getting the address of the max value (Cell function)
08:06 Closing thoughts
Watch video Dynamic navigation using hyperlinks - quickly "jump" to Max/Min in Excel online without registration, duration hours minute second in high quality. This video was added by user ExcelMoments 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 523 once and liked it 55 people.