根据Google表格中单个列中的重复项删除行 [英] Remove rows based on duplicates in a single column in Google Sheets
问题描述
我的电子表格与此类似:
我想根据第一列数据删除所有重复的行。
因此,从这个截图行中,1和2将被保留,第2行将被删除。任何帮助将不胜感激。
P.S。在我的情况下,我有从A到AU的列和从2到9500行的列。
谢谢。
我会...
1.创建一个新工作表
2.对于列A,do = Unique(Sheet1!A:A)
3.只需使用VLOOKUP填充其他列。这将提供与重复相关的第一个值。
I have spreadsheet similar to this:
I'd like to remove all duplicates of row based on the first column data.
So from this screenshot row, 1 and 2 would be kept, and row 2 would be removed. Any help would be greatly appreciated.
P.S. In my case I have columns from A to AU and rows from 2 to 9500.
Thank you.
I would... 1. Create a new sheet 2. For column A, do =Unique(Sheet1!A:A) 3. Simply use VLOOKUP to populate the other columns. This will deliver the first value associated with the duplicates.
这篇关于根据Google表格中单个列中的重复项删除行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!