HYPERLINK – Excel Functions

GoLast to jump to last cell in a column

July 20, 2020 ANmar

Edit 2021-07-12: I needed this formula to work in a worksheet having space in its name, so original one did not work, here is the new version: =HYPERLINK(“[“&MID(CELL(“filename”,A1),SEARCH(“[“,CELL(“filename”,A1))+1,SEARCH(“]”,CELL(“filename”,A1))-SEARCH(“[“,CELL(“filename”,A1))-1)&”]'”&MID(CELL(“filename”,A1),SEARCH(“]”,CELL(“filename”,A1))+1,500)&”‘!B”&COUNT(B:B)+6,”Go Last”) Again, above formula works in a worksheet with space in its name (and any other character), it already works in a workbook with space in its…

CELL, COUNT, Formulas - combined functions, HYPERLINK, Information, Lookup and References, Standard functions

Hyperlink usage and HyperlinkOf UDF

January 21, 2012 ANmar No Comments

The Hyperlink function is really powerful and yet not widely used. You can create a whole navigation system with Hyperlink fx or create a custom jump to link to take user to certain area. Of course the “Jump-to” link need other functions, like Match, Indirect and Index Here is a sample of what we can do…

CELL, Formulas - combined functions, HYPERLINK, HyperlinkOf, Information, Lookup and References, MID, Standard functions, User-Defined f(x)s = UDF