LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default Can you identify the maximum value in an array?

Dim Arr(5) as integer

Arr(2) = 99
Arr(3) = 101

How do I then find out what the maximum value is, and what position itıs at
in this type of array * i.e. for the above, the maximum is 101, at position
3.

Iıve had success with

Application.WorksheetFunction.Large(Arr, 1)

But still canıt get the position of that number.

Iım attempting this with an array that is 1000 in size if thatıs going to
be a problem ...

Thanks,

Brad.)



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Array formula to Identify Leading Zeros. Commish Excel Discussion (Misc queries) 2 December 22nd 09 04:13 PM
How do identify if a number is NOT in an array? Ed Excel Discussion (Misc queries) 1 April 15th 09 04:33 PM
Finding Location of Maximum Value in 2D Array [email protected] Excel Discussion (Misc queries) 17 November 10th 06 02:36 PM
Finding Location of Maximum Value in 2D Array [email protected] Excel Worksheet Functions 15 November 9th 06 05:23 AM
Identify occurence in "array" which meets condition(s) Melissa Excel Discussion (Misc queries) 3 August 18th 05 12:59 PM


All times are GMT +1. The time now is 11:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright İ2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"