max value into an array and index

[MrReds]

Hi there !
Hope somebody could help me.
I don’t know if I am looking for the more complex solution, but I’ll try.
I am getting different results from a routine called into a for cycle.
These results are stored in some arrays.
Let’s say
Result1(i)
Result2(i)
Resultn(i)

At the end, if the cycle is called from 1 to k, I will have n x k results.

I’d like to realize a routine capable of
1 - identifying the max of result1 among all the k result1,
and
2 - extracting the index i so that I can access to the other results of this index, as Result2, Resultn.

ex, should Result1(4) be the max of result1, I'd like to
- get the 4, so that I can access to Result2(4), Resultn(4)...

Please, has anybody any idea of how to do it ?


Thanks in advance !

[Marcol]

A non VBa way might be to use MATCH() to get the required index.
Then use INDEX(Match()) to get the corresponding values in the other arrays/ranges.

See the attached.
Does this help?

[Marcol]

The Go Advanced option when Editing a post seems to be broken, so I can't just change the attachment, I have added C/F to this example to make it easier to follow.

[MrReds]

Hello, many thanks Mr. Marcol.
As a matter of fact I was looking for a way to implement in a VBA code.

Please, do you know how to do ?

Many thanks