阅读背景:

删除重复的行,但保留整个行在特定单元格中具有最高值

来源:互联网 

I have an excel sheet with 17 columns (column A to column S). Column A contains ID numbers, column C is a date column and column F contains values in time format (hh:mm). For the same date/day, some ID numbers contain two values in column F - usually a high number (many hours and min) and a low number (few minutes). If there is such a duplicate, I want the entire row containing the low value in column F to be deleted from the sheet. I have an excel sheet with 17 columns (column A




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: