vba code to apply formula for a number columns and dynamic number of rows and then copy paste only values over them
Solved by X. H. in 22 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
Need a formula to count unique values in a column based on criteria in another column (dates), without using an array formula. need the formulas to be dynamic
Solved by V. F. in 18 mins
Can the counter variable for an Excel VBA be an array element? [ie, For A(N) = 1 to 9]