Related Posts
Additional Posts in Excel Genius
Still don't have xlookup. #fomo
Anyone know what these badges are?

New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
Still don't have xlookup. #fomo
Anyone know what these badges are?

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Download the Fishbowl app to unlock all discussions on Fishbowl.
Copy and paste embed code on your site

Scan your QR code to download
Fishbowl app on your mobile

Yes you can use the remove duplicate functionality by selecting which part of the duplicate URL you want to remove from the 80K data
How would the remove duplicates work if the url is within the labeled hyperlink? Wouldn’t it just remove the duplicate labels?
Subject Expert
Use a VBA code to extract the link from that given cell
Use =UNIQUE() to remove duplicates
It's an easy code to develop (just use .hyperlinks), but there are lots of ready to use codes on stackoverflow for this one if you wanna skip it
Yeah, it’s a pain
I agree with this. I think only VBA could pull out the actual hyperlinks, then you could just do a standard ‘remove duplicates’ or do a countif to see which ones appear more than once.