VBA Excel Data Cleaning

Job ID: 31344425

Budget: $30 – $250 USD

I have 9 columns of data (i.e., 9 variables) with 2024 cases each in Excel (Microsoft 365, *.xlsx). I want to do pairwise Pearson correlations with these 9 variables (i.e., 36 correlations; e.g., var1 with var2, var1 with var3, var1 with var4,...., up to var1 with var9; var2 with var3, var3 with var4,...., up to var3 with var9, etc.). Each variable contains cases that are either not applicable (coded 98) or blank. For each of the 36 variable pairs I need you to delete cases in which either of the two variables in the pair shows "98" or blank. Then, pairwise correlations can be run on each of the 36 pairwise sets. Each variable pair and correlation statistic can be output into a separate worksheet within the original data workbook.

Please see the attached Excel file for the raw data.

This will be a fixed price contract and I need it done within 24 hours.