Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

Posting as :
works at
You are currently posting as works at

Yes you can use the remove duplicate functionality by selecting which part of the duplicate URL you want to remove from the 80K data

like

How would the remove duplicates work if the url is within the labeled hyperlink? Wouldn’t it just remove the duplicate labels?

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

like

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.

like

Related Posts

Anyone have recommendations on the best app/site to learn Python? 🐍
I’m a complete beginner.

like

I will start managing the sales team I’m part of and transition from being a peer to becoming their manager. Any advice on how to make this change as smooth as possible?

like

Is a side-venture of real estate (buying of rental property) noteworthy in the application process? In terms of extra curriculars...

like

Let's say through a combination of aggressive saving, high income, and savvy investments, I manage to save several million by the time I'm 40.

If at that time I decided to pursue my passion and go to law school so that I can be an affordable attorney for worthy causes, will my age hold me back from getting into law school?

likeupliftinghelpful

Any advice for someone looking to transition into a full HR Generalist role from Recruiting. I’m currently a Campus Recruiter with about 5 years of HR experience (Coordinator- Higher Ed). I received my PHR certification in September 2020 and sitting for my SHRM-CP in two weeks. I’m having a hard time transitioning into a full Generalist position.

like

Hi 👋. I posted here a few weeks ago about being nervous conducting a PIP conversation with my team member.
I did it this week and let me just say it was the weirdest conversation ever. The guy is usually argumentative and tries to disprove every bit of feedback. But this time he just sat there and asked no questions and said nothing.
Maybe he’s looking for new jobs already - don’t mind this at all and this would be a good outcome for him overall.

like

Hi Techies,

Having an overall experience of 11 years, in which 6 years in Multi-Cloud, DevOps, Cloud Engineering, Cloud Cost Management, Governance and FinOps.

Any chances of oppurtunities in abroad with sponshorship?

like

Any Recruitment Project Managers willing to share salary and location (even East Coast, West Coast, etc,)?
Thank you !

like

What will be the take home and what is special allowance?

Post Photo
like

Need a quick help
While structuring the HRA if we give max limit for eg., 20k and I have rent agreement of 7500. Will this be a problem or will I just get an exempt of 7500?

like

Which bank account is better for salary account?

HDFC
Axis

like

Will Infosys revise my offer letter if I will show them other company offer which is paying me more.
Infosys offering : yoe6+ SR. Consultant (5A)18lap with 15% variable

like

If someone needs linkedin premium for 6 month. Pls message me

like

Anyone leave Deloitte for Booz Allen? Thoughts or experiences? Utilization and compliance are absolutely doing my head in.

like

Looking for senior Business Analyst for a technology consulting project (robotics process automation). Small fast paced team with great client, salary range 100-130k. CBP badge required (active is preferred, recent or equivalent clearance is OK too). DM me for details and job posting

like

Lately I’ve been seriously considering making the transition to product marketing. Current PMMs please weigh in — on average, how many hours do you actively work in a day?

like

I know it could differ depending on the company, but is It feasible to make 100k-200k as a client-side creative in NYC/be successful w. only client experience?

I need an opinion, which field is better in terms of compensation and work/ life balance , a sales producer or adjuster ??

like

Hi all! I’m currently a commercial account manager at an independent agency with 3.5 years experience….looking to move to underwriting. Any leads on where to start? I’m located in the New England area and would love to be remote.

like

I’m feeling stagnant in my career and looking for ways to grow. I was considering obtaining a PMP certification and wondering how impactful this is. Is this certification well recognized?

like

Additional Posts in Excel Genius

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

like

Still don't have xlookup. #fomo

like

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

like

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

like

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

like

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

like

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

Anyone know what these badges are?

Post Photo
likefunny

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal