| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HYPERLINK
I have a hyperlink. I wish to change the number 35473 automatically
based on the count formula. The current count is 35500. With this formula, I have to still change it manually. Thanks. =HYPERLINK("#DATA!B35473",COUNT(B8:B50000)+7) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HYPERLINK
Try this...
=HYPERLINK("#DATA!B" & <count formula,COUNT(B8:B50000)+7) If that is the same count formula.. =HYPERLINK("#DATA!B" & COUNT(B8:B50000)+7 ,COUNT(B8:B50000)+7) If this post helps click Yes --------------- Jacob Skaria "rhhince" wrote: I have a hyperlink. I wish to change the number 35473 automatically based on the count formula. The current count is 35500. With this formula, I have to still change it manually. Thanks. =HYPERLINK("#DATA!B35473",COUNT(B8:B50000)+7) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert hyperlink function into hyperlink | Excel Worksheet Functions | |||
| Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
| How do I create a hyperlink to a cell with the hyperlink function | Excel Worksheet Functions | |||
| Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
| Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
![rhhince[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
