Thread: Does Correl/Rank combo work eg CORREL(cols E & H) where E&H=RANK(.
View Single Post
  #2   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default Does Correl/Rank combo work eg CORREL(cols E & H) where E&H=RANK(.
You need to provide more information.

Jerry

Emmanuel wrote:

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

Reply With QuoteReply With Quote