Entering UDF as an Array

[kingofaces]

I have a function called ModelAccuracy that returns multiple variables in an array on the spreadsheet.

ModelAccuracy = Array(CCC, R, Cb, RMSPE, ECT, ER, ED)

Now if I enter the formula into an array that's 1 row by 7 columns, each variable is entered into the appropriate cell. However, if I make the array vertical (7 rows by 1 column) the CCC term is repeated for all 7 terms. Is there a way for all variables to show up in this vertical array?

 

[mikerickson]

Put the array formula =TRANSPOSE(ModelAccuracy()) in a 7 row X 1 column range.

 

[kingofaces]

Thanks, that did the trick. I was wondering if transpose could be used, but I had forgotten is was an actual function in excel.