英文:
Removing several desired rows from excel sheet using the second sheet
问题
如何删除在另一个Excel表中具有相同值的特定行?当然,有许多列,但我筛选以使第二张表中保留特定行,并且在第一张表中也有这些值以及其他值。例如,下面我想从第二组中删除具有第二组第一列中相同值的行。其余部分不重要。
第一组:
A B C
1 2 3
4 5 6
7 8 9
10 1 1
第二组:
A B C
1 5 6
3 3 9
7 7 6
英文:
How can I remove specific rows which has the same values in another excel sheet? of course there are many columns but I filter such that specific rows remained in the second sheet and we have those values in first sheet as well as other values. for example below I want to delete rows from second set with the same value in the first column of second set. rest does not matter
A B C
1 2 3
4 5 6
7 8 9
10 1 1
second set
A B C
1 5 6
3 3 9
7 7 6
答案1
得分: 1
这检查A2:A4范围中的值是否在另一个工作表的A列中:
使用的公式(我用逗号替换了´;´)
> ISNUMBER(XLOOKUP(A2,Sheet2!$A:$A,Sheet2!$A:$A,"NOPE"))
唯一剩下的事情就是按颜色筛选并删除行。请记住,如果要删除的行不是连续的话,在大量删除时可能会比较慢。
英文:
This checks if the value in A2:A4 is in the other sheet in the A-column:
Formula used (I replaced the ´;´ with ´,´)
> ISNUMBER(XLOOKUP(A2,Sheet2!$A:$A,Sheet2!$A:$A,"NOPE"))
The only thing left to do is filter by color and delete the rows. Though do remember that deleting rows in larger quantities, if they're not continuous, can be quite slow.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论