Forum Discussion
Unique Values with Hyperlink Carry Over
Hi there!! I am working on finding an Excel solution, if one exists, that recreates some functionality within Google Sheets that we have been using and want to switch entirely into Microsoft. I h...
Instead of using the UNIQUE function, please select the data and use Data>Remove Duplicates.
I believe this will retain the hyperlink.
- I appreciate the suggestion, but unfortunately for what this is supposed to do I don't think that will be a viable option. The end goal of what this accomplishes is that it selects all of the correspondence with a client, and each correspondence is recorded as an individual row in that dataset. The sheet that has the unique function has several other functions on it, but what it mainly does is finds the most recent correspondence with the client and pulls some metrics and conditional formatting based on company criteria.
For example we have the data set with 10000 rows, but only have 200 clients. The unique function pulls out the 200 clients, and the other formulas populates the columns in the row with the information pertaining to the most recent contact we've had with the client.
I hope that makes sense, but also illustrates why I think the remove duplicates feature may not work.
Thanks!I believe you're going to need a VB function to pull those hyperlinks. There may be a UDF you can nest with UNIQUE that's array friendly.
HansVogelaar or OliverScheurich may be able to help.
- Thank you for the response! I was afraid that might be the case and likely out of my wheelhouse. Definitely a bummer that it works in something basic like Sheets but not in the superior tool, Excel. Maybe someone from Product will see this and decide to implement it some day!
