Results 1 to 5 of 5

Formula for finding Start, Stop, Highest and Lowest value

Threaded View

mariur89 Formula for finding Start,... 05-05-2016, 05:33 AM
oeldere Re: Formula for finding... 05-05-2016, 05:52 AM
Phuocam Re: Formula for finding... 05-05-2016, 05:54 AM
samba_ravi Re: Formula for finding... 05-05-2016, 06:04 AM
José Augusto Re: Formula for finding... 05-05-2016, 06:07 AM
  1. #1
    Registered User
    Join Date
    11-24-2014
    Location
    norway
    MS-Off Ver
    2010
    Posts
    37

    Formula for finding Start, Stop, Highest and Lowest value

    Dear Excel pros!

    I want to find and extract the following information from a matrix:

    - The first registered value within a specific date ("Start")
    - The last registered value within a specific date ("Stop")
    - The highest registered value within a specific date
    - The lowest registered value within a specific date

    (This will look very much like a table of stock values).

    So I need the four formulas to find this information within a table ("'Table 1") and copy the data to a new table ("Table 2").

    Please see the attached file for more information.

    Thank you in advance!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Using Stochastic formula find highest or lowest
    By DavidRoger in forum Excel General
    Replies: 8
    Last Post: 10-21-2015, 01:32 AM
  2. [SOLVED] In need of a formula to rank highest to lowest
    By ellie2014 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-30-2014, 12:48 AM
  3. [SOLVED] finding the X highest (or lowest) numbers in a set.
    By jimboryan in forum Excel General
    Replies: 3
    Last Post: 07-25-2014, 02:20 AM
  4. [SOLVED] Finding the category with the highest/lowest score
    By Vemonstrocity in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-08-2012, 07:08 PM
  5. Finding the highest or lowest value
    By simonjg in forum Excel General
    Replies: 0
    Last Post: 09-18-2011, 10:39 AM
  6. Finding highest and lowest number between to key numbers
    By garbs in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-10-2007, 06:35 PM
  7. Formula for highest/lowest cost
    By S S in forum Excel General
    Replies: 2
    Last Post: 04-29-2006, 11:25 AM

Tags for this Thread

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