Does anyone know the best way to input multiple data arrays into Excel functions which have more than one argument?
For example, I have a data set of 1700 rows and 450 columns which I have had to split over two worksheets. I want to calculate the upper quartile of each of the 1700 rows but the QUARTILE function only allows one array argument so you cannont enter array_sheet1,array_sheet2 as it will read array_sheet2 as the quartile argument.
Many thanks
For example, I have a data set of 1700 rows and 450 columns which I have had to split over two worksheets. I want to calculate the upper quartile of each of the 1700 rows but the QUARTILE function only allows one array argument so you cannont enter array_sheet1,array_sheet2 as it will read array_sheet2 as the quartile argument.
Many thanks
