The two data sets must be of equal length to use the CORREL function in Excel. If the two data sets are of unequal length, we need to use an array formula instead.