I have a problem recently that is quite challenging.

My spreadsheet has about 54 worksheets. Each worksheet has 4 columns and it organized by a category I picked.

Column A = Url
Column B =Random number
Column C = Website Name

Ideally my goal is to check every single url and make sure they are not duplicated in any other worksheet, but that might not be possible. For now, I'm sticking to checking each worksheet one by one.

I tried conditional formatting and it works great to isolate and color code the duplicates, but there is a problem. Sometimes the url has a / at the end and sometimes it doesn't, so the software will not recognize it.

Example
A B C
https://www.websiteurlhere.com 48965 Website Name
https://www.websiteurlhere.com/ 85794 Website Name

I have no idea how to get Excel to recognize the two url examples above as duplicates and highlight them. I suppose I could attach a / to every cell that doesn't have the symbol, but I don't think that is feasible given the number of urls in each spreadsheet.

Does anybody have any suggestions or recommendations?

Thanks.