Sorting and Deleting

[tobysdhc]

Hello,

I have a data sheet with columns A-R and about 3200 rows. Column A is a work order number and Column K represent the amount of days it took to complete that work order.

There are situations in which there are duplicate work order numbers (2 jobs at once) and that results in two different dates to complete. I would like to know if there is a way to delete the duplicate row with the lower of the two number in column K.

Below is an example. I would like to know if I can automatically delete Row "1234567" that has "34" days to complete and "3456789" that has "76" days to complete rather than having to go through all 3200 rows. Thank you!

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Worker Number[/TD]
[TD]Data[/TD]
[TD]Data[/TD]
[TD]Data[/TD]
[TD]Data[/TD]
[TD]Data[/TD]
[TD]Data[/TD]
[TD]Data[/TD]
[TD]Data[/TD]
[TD]Days to complete[/TD]
[/TR]
[TR]
[TD]1234567[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]34[/TD]
[/TR]
[TR]
[TD]1234567[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]58[/TD]
[/TR]
[TR]
[TD]2345678[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]45[/TD]
[/TR]
[TR]
[TD]3456789[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]76[/TD]
[/TR]
[TR]
[TD]3456789[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]93[/TD]
[/TR]
[TR]
[TD]4567890[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]13[/TD]
[/TR]
[TR]
[TD]5678901[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]23[/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

You could use a helper column with
=MAX(IF($A$2:$A$8=A2,$K$2:$K$8))=K2
this is an array formula & needs to be confirmed with Ctrl Shift Enter
Then filter on false & delete them

 

[tobysdhc]

That worked great! Thank you so much!

 

[Fluff]

You're welcome