I tried using the SLOPE function but got #N/A as my first 4 values in column A equal #N/A. In column B all the values are numbers. So i used
=SLOPE(IF(ISNUMBER(Monthly!$A2:$A37),Monthly!$A2:$A37),IF(ISNUMBER(Monthly!B2:B3),Monthly!B2:B3))
however i am now getting #Value !
the dataset is below:
<colgroup><col><col><col></colgroup><tbody>
</tbody>
=SLOPE(IF(ISNUMBER(Monthly!$A2:$A37),Monthly!$A2:$A37),IF(ISNUMBER(Monthly!B2:B3),Monthly!B2:B3))
however i am now getting #Value !
the dataset is below:
#N/A | 2.30242 | |
#N/A | -5.9716 | |
#N/A | -2.87481 | |
#N/A | 4.456949 | |
13.60761 | 0.216091 | |
-6.96379 | -1.37079 | |
-3.83234 | -3.14611 | |
-5.66625 | 0.297976 | |
13.20132 | 1.474965 | |
3.950608 | 0.780809 | |
3.293586 | 0.235856 | |
-5.27762 | 2.498126 | |
10.50494 | 3.936338 | |
16.17646 | 1.186693 | |
4.475582 | 1.572824 | |
-4.05762 | 0.340843 | |
-1.64835 | -2.01001 | |
14.99069 | 4.897094 | |
-9.06882 | -0.38624 | |
4.407835 | 2.466393 | |
15.5224 | 0.925279 | |
11.59099 | -0.68948 | |
5.963445 | 3.876102 | |
0.063753 | -2.7672 | |
-2.23001 | 1.099896 | |
3.681982 | 0.661862 | |
-4.39975 | -0.56691 | |
4.980183 | 1.674116 | |
-0.38083 | -2.03633 | |
1.943302 | 4.66007 | |
-8.06251 | -1.99345 | |
6.254244 | -3.77145 | |
-16.3148 | -2.1961 | |
5.504584 | 5.996406 | |
-4.17035 | 2.289903 | |
-0.70204 | -0.47251 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>