Get instant live expert help on How do I return largest numbers in arrays
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I'm trying to make a VBA function with two arrays; the first array has the numeric values while the second array has the names. The function will find the value in the first array that is the largest and return the corresponding name (from the second array).
Solved by D. Y. in 11 mins
I'm using excel for financial analysis, and I want to sum numbers of the 2nd largest product. The product numbers, where I would calculate if it was the 2nd largest, are different than the numbers I want to sum. Any ideas?
Solved by O. B. in 24 mins
I need help with excel rank formula without skipping numbers. I have to rank 280 numbers from smallest to largest in groups of %10, so the smallest 28 numbers are 1 and the largest are 10. I'm sure this is simple for an expert!
Solved by I. Q. in 23 mins
I have 4 arrays and I want the fifth array to combine all values of the 4 arrays
Solved by C. Q. in 11 mins
Hey I need help with VBA.
The first functions that you will create are helper functions that can be used by otherfunctions.
Function FindMax(valueArray, nameArray) As String
This function takes in two arrays; the first array has the numeric values while thesecond array has the names. The function will find the value in the first array that isthe largest and return the corresponding name (from the second array). For instance, if the valueArray = (10, 20, 5, 9) and nameArray is (“House”, “Chair”,
“Table”, “Book”). The function will return Chair.
Solved by F. A. in 24 mins