Finding highest/lowest value in a group and deleting other rows

[wxrocks]

Yikes -- 2 computer questions in the same day??!??!?

Does anyone have code for selecting a group of rows, checking one column for the highest/lowest value of the group, deleting the other rows -- then moving to the next group?

Just trying to save some time. Thanks!

 

[NoTime]

You can use the VB script language built into excel.