Apr 16 2019 02:45 PM
I filter out a column to show only cells that have a certain value, and then I wish to add a simple hyperlink (right click, link) to a separate PDF document.
When I do this, all of the filtered out, non visible cells in between the the cells that I wish to add links to also get linked. They do NOT get text added to them or modified, but they absolutely get a link added.
How can I avoid this?
Mar 30 2023 12:53 AM
Mar 30 2023 12:56 AM
One possible solution is to create a new column with the hyperlink and then use the FILTER function to only display the filtered cells in that column. Here are the steps you can follow:
=FILTER(B:B,A:A="value")
This should allow you to add hyperlinks only to the cells that are visible after filtering, without affecting the hidden cells.
Mar 30 2023 01:40 AM
Mar 30 2023 04:07 AM
Here is an example of an external reference formula in Excel:
=HYPERLINK("[Path]FileName!Cell","DisplayText")
Replace [Path] with the path to the workbook that contains the cell you want to reference. Replace FileName with the name of the workbook and Cell with the cell address. Replace DisplayText with the text you want to appear in the hyperlink.
I hope that helps!