Results 1 to 7 of 7

Read a Row and catch the maximum and minimum points

Threaded View

  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:

    B         E
    0,02    0,02
    0,14    0,26
    0,21    -5,56
    0,24     ....
    0,26
    0,25
    0,23
    0,17
    0,07
    -0,12
    -0,40
    -0,78
    -1,24
    -1,75
    -2,28
    -2,80
    -3,31
    -3,79
    -4,23
    -4,66
    -5,03
    -5,31
    -5,50
    -5,56
    ...
    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.

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