Get instant live expert help on I need help with vba for each 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
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
VLOOKUP, ARRAY_CONSTRAIN, SMALL, IF, ROW, ARRAY, IFS, COUNT, COUNTIF, COUNTIFS, INDEX, MATCH, VBA
Solved by O. D. in 21 mins
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 have a series of functions that involve averaging the values surrounding the minimum value of an array, and for each array the point in the array where the minimum can vary. Is there a function or combination of functions that will allow me to (for example) average(location(min(array)+2):location(min(array)-2))? A method to read out variable cell locations?
Solved by B. B. in 13 mins
I need a VBA that exports each individual row into an individual txt file. The VBA should use the column headers as pretext for each result. E.g. column header=cell content
Solved by Z. H. in 16 mins