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!

Worker Number	Data	Data	Data	Data	Data	Data	Data	Data	Days to complete
1234567									34
1234567									58
2345678									45
3456789									76
3456789									93
4567890									13
5678901									23

<tbody>
</tbody>

 

[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