Some corrections & refinements to the earlier post ..

Put instead in B3:
=PEARSON(OFFSET(Ranks!$A$3:$A$230,,ROWS($A$1:A1)),
Ranks!B$3:B$230)

(corrections made for cell refs)

With B3 selected,
Click Format Conditional Formatting (CF)
Under condition 1, make the settings as:
Formula is: =ROWS($A$1:A1)COLUMNS($A$1:A1)
Click Format button Font tab Font Color white OK
Click OK at the main dialog

Copy B3 across to DT3, fill down

The CF will make the diagonal half below "invisible"
(assuming the fill color is the default: no color)

If you don't want the diagonal 1's to appear as well,
just change the CF formula in the starting cell B3 to:
=ROWS($A$1:A1)=COLUMNS($A$1:A1)
and copy across/fill down as before
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--