I've got a excel spreadsheet of imported broken links with their parent page. I need to sort by the error code, i.e. find all broken links with the error code 404. The issue I'm having is that I need to know what parent page they are coming from after the sort. Below is a screenshot, the parent page is the first URL at A1 and then every URL without an error code next to it (A19, A23,A33 in the screenshot). The links below the parent URL belong to that parent page.
我有一个excel电子表格,其中包含导入的断开链接及其父页面。我需要按错误代码排序,即找到所有损坏的链接,错误代码为404.我遇到的问题是我需要知道排序后它们来自哪个父页面。下面是截图,父页面是A1的第一个URL,然后是每个没有错误代码的URL(屏幕截图中的A19,A23,A33)。父URL下面的链接属于该父页面。
So how would I sort by error code and be able to see what the parent page is for the links after the sort?
那么我如何按错误代码排序并能够在排序后查看链接的父页面是什么?
1 个解决方案
#1
0
Seems that with deleting blank rows (filter may be easiest for this) and inserting a column on the extreme left with =B1 in A1 and in A2 copied down to suit:
似乎删除了空白行(过滤器可能最简单),并在最左边插入一列,在A1中键入= B1,在A2中向下复制以适合:
=IF(ISBLANK(C1),B1,A1)
met the requirement.
符合要求。
#1
0
Seems that with deleting blank rows (filter may be easiest for this) and inserting a column on the extreme left with =B1 in A1 and in A2 copied down to suit:
似乎删除了空白行(过滤器可能最简单),并在最左边插入一列,在A1中键入= B1,在A2中向下复制以适合:
=IF(ISBLANK(C1),B1,A1)
met the requirement.
符合要求。