Do the identical for every subsequent “URL # hyperlinks to A?”. line.
References to column B “Hyperlink to focus on URL” don’t change, however references to associated URL columns do. for instance:
F2 (“URL 2 hyperlinks to A?”) appears for the E2 URL within the checklist of URLs in B2.
=IF(ISNUMBER(SEARCH(E2, B2)), "Exists", "Not Discovered")Copy this system into column F. H2 searches for the G2 URL in B2’s URL checklist.
=IF(ISNUMBER(SEARCH(G2, B2)), "Exists", "Not Discovered")Copy this system into column H. Repeat this course of for every “URL # hyperlink to A?” Column.
Spotlight lacking hyperlinks for simple affirmation
- Choose columns D:L and in Google Sheets (or Excel)[形式]->[条件付き書式]Moved to.
- I arrange a rule to show cells containing “Not Discovered” in pink coloration for simple identification.
This makes it simpler to determine the place inside hyperlinks are lacking.
Validate the information
I manually double-checked a number of entries to make sure all the pieces was correct. You now have an entire checklist of every goal URL in column A, the highest 5 associated URLs, and whether or not these URLs hyperlink to the goal URL.
The ultimate spreadsheet appeared like this, with every associated URL indicating whether or not it linked to the goal URL by indicating whether or not it was current or not discovered.
