更新时间:2023-02-02 21:58:05
发现自己: / p>
要删除重复值,请使用数据选项卡上
数据工具组中的删除重复命令。
I have a table in excel. E.g.
col1 col2
A Something
A Something else
A Something more
A Something blahblah
B Something Fifth
B Something xth
C Som thin
F Summerthing
F Boom
And I want only rows without duplicate col1: e.g:
col1 col2
A Something
B Something Fifth
C Som thin
F Boom
Is there any way of filtering rows like this :) ?
Found it myself:
To remove duplicate values, use the Remove Duplicates command in the Data Tools group on the Data tab.