It would probably help if you described some of your failed attempts. The CORREL() function seemed to work just fine for me on that data set (result ~0.4).

You might review this: https://support.office.com/en-us/art...b-239d7b68ca92 and see if any of the error conditions mentioned under "Remarks" exists.