I get nonsensical results for =CORREL($E43:$E61,H43:H61) where columns E and
H are of the type =RANK(G58,G$43:G$61,1). Does this combination work
correctly?
Both CORREL and RANK are working with simple varables.

Thanks