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