+ Reply to Thread
Results 1 to 3 of 3

VBA to determine the lowest and the highest Score in the data Table

Hybrid View

  1. 08-27-2014, 04:53 AM #1
    Faridwahidi
    Faridwahidi is offline
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    702

    VBA to determine the lowest and the highest Score in the data Table

    Hi,

    I have a data table which represent score value in Range("A1:E10")

    can anyone help me to write vba code to determine the highest and lowest score value?
    Reply With QuoteRegister To Reply
  2. 08-27-2014, 05:02 AM #2
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: VBA to determine the lowest and the highest Score in the data Table

    why not use the formula Large and Small for that?
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  3. 08-27-2014, 11:10 AM #3
    Faridwahidi
    Faridwahidi is offline
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    702

    Re: VBA to determine the lowest and the highest Score in the data Table

    Hi Oeldere,


    You are pretty good. I am overlooked this function. Thanks a lot.

    MsgBox Application.WorksheetFunction.Large(Range("A1:E10"), 1)
MsgBox Application.WorksheetFunction.Small(Range("A1:E10"), 1)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. using a table to remove highest and lowest values
    By jimboryan in forum Excel General
    Replies: 0
    Last Post: 07-31-2014, 12:35 PM
  2. Match golf players name to their score in desscending order of highest winning score.
    By thomsonperrett in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 11-24-2013, 07:53 AM
  3. [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
  4. Need to find the highest score and use a secondary score if duplicate high score
    By kattster in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-20-2012, 06:30 PM
  5. table that updates automatically with the name & highest score
    By geoffbanks in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-13-2011, 11:59 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1