Thread: Correlation Matrix

I have a correlation matrix used for financial data. The correlations update daily and include over 700 data points in total. I have ranked the 5 strongest positive and 5 strongest negative correlations, however I cannot figure how to label the series. On any day the data will change. I have tried match, index and offsets but cannot get to work. any ideas?

Judging from what you say there, you will need a sort of ranking system. Try using the RANK function and see what it does.

It would help if you could post a sample workbook for us to look at and play with.