Forum Discussion

GadiSol's avatar
GadiSol
Copper Contributor
Dec 18, 2022

Another CORREL question

How can I get CORREL to ignore rows in which one of the cells is empty?

 

Thanks!

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    GadiSol 

    Did you read the help article on the function?

     

    Spoiler
    If an array or reference argument contains ... empty cells, those values are ignored ...

Resources