Get instant live expert help on I need help with vba function return array
“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
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
VLOOKUP, ARRAY_CONSTRAIN, SMALL, IF, ROW, ARRAY, IFS, COUNT, COUNTIF, COUNTIFS, INDEX, MATCH, VBA
Solved by O. D. in 21 mins
Specs: This is a spreadsheet that supplies an email address for clients. The cells D-G will be returned by SQL lookup (cont.xlsx). The complete company client array is at right of sheet columns D-G. Clients entered in column B should return data for cols D-G Perform an array search where cell C matches Cell H. The array search should return all corresponding match cells I into Columns B Some companies will have multiple names associated. Some names/companies will not be in the array but should return data D-G. The array should return all associated names to column B
Solved by V. W. in 28 mins
Can the counter variable for an Excel VBA be an array element? [ie, For A(N) = 1 to 9]
Solved by G. A. in 24 mins