Computer Questions: Find Highest/Lowest Value & Delete 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.

 

[ravenprp]

Hi there,

I completely understand the frustration of having multiple computer questions in one day. However, I am happy to help with your request.

To find the highest/lowest value in a specific column and delete the other rows, you can use the following steps:

1. Sort the data by the column you want to check for highest/lowest value.
2. Select the first row with the highest/lowest value.
3. Press and hold the "Shift" key on your keyboard.
4. Select the last row with the highest/lowest value.
5. This will highlight all the rows in between.
6. Right-click on the highlighted rows and select "Delete" or press the "Delete" key on your keyboard.
7. This will delete all the rows except for the one with the highest/lowest value.

To continue this process for the next group, you can repeat the above steps or use the "Find and Replace" function to find the next highest/lowest value in the column.

I hope this helps save you some time. Let me know if you have any further questions.