Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Excel code

  1. Nov 1, 2006 #1
    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!
  2. jcsd
  3. Nov 1, 2006 #2


    User Avatar
    Science Advisor
    Homework Helper

    You can use the VB script language built into excel.
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook