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.
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Have something to add?

Similar Discussions: Excel code
  1. Histograms in Excel (Replies: 4)

  2. Excel summing (Replies: 3)

  3. Excel + Calculations (Replies: 9)