
Correlation in Excel using Data analysis add-in with a criteria
Hello, I am trying to find the correlation for several columns at a time. I have used data analysis add-in and I want to apply a condition to go with. for example, my worksheet have data about clients having paying difficulties and clients with no payment difficulties. so,by using data analysis toolpak I am getting correlation of entire data but i want to get the correlation for clients with payment difficulties only. I have tried to use =correal() with nested if function =CORREL(IF (Table13[TARGET]=Correlations!$B$4,Cleaned_data!$H$2:$H$50000), IF(Table13[TARGET]=Correlations!$B$4,Cleaned_data!$G$2:$G$50000)). It gives the correct correlation but i have manually enter this formula for each row. Is there any way to automate this process?
Microsoft 365 and Office | Development | Other

Microsoft 365 and Office | Excel | For business | Windows
