Thanks! I checked that and noticed that I had made a mistake. To fix I reverted the sheet to a previous version. Basically, if I deduplicate column A it removes title duplicates but this misaligns the titles and the urls. If I deduplicate columns A and B together the process finds no duplicates. This is probably because the duplicate titles have different urls.
I think I will just keep those duplicates for now as that seems better than the alternatives.
I removed the Ryan link. f you see anything in the new sheet please comment there or here.
Thanks! I checked that and noticed that I had made a mistake. To fix I reverted the sheet to a previous version. Basically, if I deduplicate column A it removes title duplicates but this misaligns the titles and the urls. If I deduplicate columns A and B together the process finds no duplicates. This is probably because the duplicate titles have different urls.
I think I will just keep those duplicates for now as that seems better than the alternatives.
I removed the Ryan link. f you see anything in the new sheet please comment there or here.