Results 1 to 3 of 3

find second largest value from a list of values

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-22-2013
    Location
    Sibiu
    MS-Off Ver
    Excel 2007
    Posts
    114

    find second largest value from a list of values

    Hello people, i tried to convert "=LARGE((a,b,c,d,e,f),2)" to vba but either i'm doing something wrong or it doesnt work like the formula does.

        
    x = application.WorksheetFunction.Large((a, b, c, d, e, f, g, h, i, j),2)
    a,b,c,d... are declared as doubles as they are results of averages.
    Last edited by a.hudrea; 05-11-2016 at 04:38 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 02-24-2014, 09:29 PM
  2. [SOLVED] Find the n largest values from a set with duplicates
    By amphinomos in forum Excel General
    Replies: 7
    Last Post: 01-14-2014, 08:59 AM
  3. [SOLVED] Find second, third and so one largest unique values
    By huy_le in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 01-03-2014, 09:21 PM
  4. [SOLVED] Find nth largest value, when there are duplicate n-1, n-2 etc values
    By Bobneil in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-19-2013, 03:31 AM
  5. [SOLVED] Find Largest Values Greater than 'X' in VBA
    By mabeaver in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-12-2012, 03:47 PM
  6. Find 7th largest and smallest element in unsorted list
    By cpadude in forum Excel General
    Replies: 2
    Last Post: 06-24-2008, 05:22 PM
  7. find largest values, then return corresponding row values.
    By neurotypical in forum Excel General
    Replies: 7
    Last Post: 05-24-2006, 05:27 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