DRExcel515
Board Regular
- Joined
- Oct 20, 2017
- Messages
- 56
I was hoping to be able to use a conditional array (possibly) to get a slope formula to work. I did something similar with the STDEV.S formula... IFERROR(STDEV.S(IF($B2=Sheet2!$B$5:$B$13479,Sheet2!$E$5:$E$13479)),"NO DATA")
but can't get the slope one to work. I have a column of symbols in column "B" and want to pull the slope for each one for a specific time period if the symbol matches another column on another sheet that has all the data and dates that I need, so I've been trying to incorporate the if(b2=sheet2!B5:B13479 like I did in the STDEV.S formula above, but can't get it to work.
Any ideas? Thanks!
but can't get the slope one to work. I have a column of symbols in column "B" and want to pull the slope for each one for a specific time period if the symbol matches another column on another sheet that has all the data and dates that I need, so I've been trying to incorporate the if(b2=sheet2!B5:B13479 like I did in the STDEV.S formula above, but can't get it to work.
Any ideas? Thanks!
