+ Reply to Thread
Results 1 to 3 of 3

Finding Max value in one column of a 2D array

  1. 03-12-2014, 07:51 AM #1
    Chimpy
    Chimpy is offline
    Registered User
    Join Date
    04-25-2013
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    10

    Finding Max value in one column of a 2D array

    Hi all,

    I have a 2d array in vba and am trying to find the maximum value in the 12th column and return the position in the array and the value. Any help would be greatly appreciated.

    Thanks
    Reply With QuoteRegister To Reply
  2. 03-12-2014, 08:19 AM #2
    Izandol
    Izandol is offline
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Finding Max value in one column of a 2D array

    You may use Max, Index and Match:
    Please Login or Register  to view this content.
    for example.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules
    Reply With QuoteRegister To Reply
  3. 03-12-2014, 08:29 AM #3
    MickG
    MickG is offline
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Finding Max value in one column of a 2D array

    Perhaps something like:-
    Please Login or Register  to view this content.
    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. [SOLVED] Finding Max value in one row of a 2D array (array is not pulled from sheet)
    By marrott2 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-12-2014, 06:13 PM
  2. [SOLVED] Finding cell location of a value in a multi column array
    By Bptacek in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 12-19-2013, 11:53 AM
  3. [SOLVED] Finding a number in a multi-column array and returning the value from the leftmost column
    By Carl K in forum Excel General
    Replies: 5
    Last Post: 09-12-2012, 01:27 PM
  4. Finding the value of another column using an array
    By StevenAlberta in forum Excel General
    Replies: 5
    Last Post: 06-17-2012, 05:31 PM
  5. Finding the last populated cell in a column array
    By JosephJames in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-18-2009, 12:42 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1