+ Reply to Thread
Results 1 to 3 of 3

How to find LOWEST and HIGHEST point in a class

  1. #1
    Registered User
    Join Date
    09-19-2014
    Location
    Jakarta
    MS-Off Ver
    2013
    Posts
    9

    How to find LOWEST and HIGHEST point in a class

    Hello everyone!
    So this is my second post here (sorry if my English still bad haha)

    I have a problem (of course )
    The resume of my question is:
    How to find the lowest and highest value in a class?

    Please find my attachment in this post.

    Thanks everyone
    Salam from Indonesia
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor quekbc's Avatar
    Join Date
    01-18-2010
    Location
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,149

    Re: How to find LOWEST and HIGHEST point in a class

    Selamat pagi Ihsan.

    Put this formula in M3
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    and this in N3
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    NOTE: These are array formulas, as such, you need to type in the formula and press CTRL SHIFT ENTER rather than just enter.

  3. #3
    Registered User
    Join Date
    09-19-2014
    Location
    Jakarta
    MS-Off Ver
    2013
    Posts
    9

    Re: How to find LOWEST and HIGHEST point in a class

    Wow, thanks alot @quekbc

    Its work! Terima kasih

+ 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. [SOLVED] Formula to Find the Lowest Point Between Values
    By artiststevens in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-22-2015, 05:14 AM
  2. Replies: 4
    Last Post: 01-07-2014, 03:38 AM
  3. Replies: 4
    Last Post: 07-06-2013, 04:44 PM
  4. Find highest and lowest values for a range of dates
    By kersties in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-17-2013, 05:55 AM
  5. [SOLVED] Formula to select the highest number, and the lowest and find out the range
    By Nero_slk in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-14-2013, 07:56 AM
  6. [SOLVED] Find Highest/lowest numbers!
    By stewart08 in forum Excel General
    Replies: 3
    Last Post: 04-07-2008, 12:42 PM
  7. [SOLVED] Find lowest and highest value from a set of rows
    By Paul A via OfficeKB.com in forum Excel General
    Replies: 5
    Last Post: 07-16-2005, 11:05 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