![]() ![]() Of course, any rows already containing unique IP addresses would be left alone. So, using the above example, row 3 would be deleted because the duration of 1 minute is shorter than 36 minutes in row 4 that contains the same IP address.Īnother example is that rows 5, 6 and 7 would also be removed as all their durations are shorter than row 8 which has the same IP address but a longer duration. I need a way to remove all duplicates of a particular IP address that do not contain the longest duration for that IP address. To better explain my scenario, see sample image below: However, the criteria I need is to remove whichever duplicates are not the longest duration. This data contains a number of duplicates I need to remove, based on the IP address in Column A. Column C contains duration in the following Custom format ( h:mm:ss).Column B contains Date/Time in the following Custom format ( d/mm/yyyy h:mm).Column A contains IP addresses in General format. ![]() I have a spreadsheet with thousands of rows of data. I've tried the approaches discussed here, here and here, but none work in my scenario. I'm having trouble trying to achieve this in an accurate and automated way.
0 Comments
Leave a Reply. |