+ Reply to Thread
Results 1 to 7 of 7

Read a Row and catch the maximum and minimum points

  1. #1
    Forum Contributor
    Join Date
    05-09-2013
    Location
    london
    MS-Off Ver
    Excel 2016
    Posts
    107

    Read a Row and catch the maximum and minimum points

    Hello everyone,

    I have here an Excel spreadsheet that I really would like some help. As you can see in the attached file, I have starting in column B3 to B848 several values that represents the height of a wave.

    What I would like is a macro that can read the higher and lowest values of a wave and then write it down to column E. I will do an example:

    Please Login or Register  to view this content.
    As you can see, the macro would read column B and search for the higher value, write it down to column E, then search for the minimum value before it gets bigger, and then write it on column E, then would search for the higher value and write it down again to column E.. And do this until the end of column B.

    With this I could see the height of all the waves in this data.

    Please if someone did not understood correctly please say so, I will try to explain better. Thank you

    help.xlsx
    Last edited by ropbasuel; 07-27-2014 at 09:45 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    12-02-2012
    Location
    Melbourne, VIC
    MS-Off Ver
    Excel 2016
    Posts
    750

    Re: Read a Row and catch the maximum and minimum points of waves

    try the following macro:
    Please Login or Register  to view this content.
    HTH! help2.xlsm

  3. #3
    Forum Contributor
    Join Date
    05-09-2013
    Location
    london
    MS-Off Ver
    Excel 2016
    Posts
    107

    Re: Read a Row and catch the maximum and minimum points of waves

    Dear Jewelsharma,

    Thank you so much!! This works like I really wanted to work! May I just ask you something else?

    Is it possible to include in the macro a code where F3 is (E4-E3), F4 is (E5-E4), F5 is (E6-E5)... And that until the end of all column E values.

    Thanks again, for all the help!

  4. #4
    Valued Forum Contributor
    Join Date
    12-02-2012
    Location
    Melbourne, VIC
    MS-Off Ver
    Excel 2016
    Posts
    750

    Re: Read a Row and catch the maximum and minimum points of waves

    try the following macro:
    Please Login or Register  to view this content.
    Attached example: help3.xlsm
    HTH!

  5. #5
    Forum Contributor
    Join Date
    05-09-2013
    Location
    london
    MS-Off Ver
    Excel 2016
    Posts
    107

    Re: Read a Row and catch the maximum and minimum points of waves

    Dear Jewelsharma,

    I'm sorry for the late reply. Thank you so much for that new tweak that you have added. May I bother you just one more time please? It's the last time!

    Is it possible to include in the macro a code where G3 is (1/8*(1025*9,81*F3^2)/1000) , G4 is (1/8*(1025*9,81*F4^2)/1000) and G5 is (1/8*(1025*9,81*F5^2)/1000) and so on until the end of all column F values?

    Thank you so much one more time

  6. #6
    Valued Forum Contributor
    Join Date
    12-02-2012
    Location
    Melbourne, VIC
    MS-Off Ver
    Excel 2016
    Posts
    750

    Re: Read a Row and catch the maximum and minimum points of waves

    here you go:
    Please Login or Register  to view this content.
    Test sheet attached - help4.xlsm

    May I suggest you raise follow-on requests via a new thread in future. For connectivity/continuity, you may provide a link to the previous thread in the new thread. This way, you would get a faster response to your queries. Cheers!

  7. #7
    Forum Contributor
    Join Date
    05-09-2013
    Location
    london
    MS-Off Ver
    Excel 2016
    Posts
    107

    Re: Read a Row and catch the maximum and minimum points of waves

    Dear Jewelsharma,

    Thank you again for the help! I did not know that we could do that!

    Your code is perfect!

    Best Regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Color maximum and Minimum
    By thong127 in forum Excel General
    Replies: 6
    Last Post: 01-09-2014, 11:20 AM
  2. [SOLVED] Sum minus up to a maximum and a minimum
    By Rompetelo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-18-2013, 03:58 AM
  3. Maximum and Minimum
    By lurchybold in forum Excel General
    Replies: 6
    Last Post: 10-13-2010, 11:04 AM
  4. Maximum and minimum cell value
    By sharkfoot in forum Excel General
    Replies: 3
    Last Post: 03-05-2006, 07:10 PM
  5. [SOLVED] Recording maximum and minimum
    By F in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-18-2006, 02:30 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1