View Single Post
  #1   Report Post  
Pat
 
Posts: n/a
Default Linest/slope functions with with different data ranges

I want to get the slope for different data sets compared to the same X's. As
my samples don't necessarily have the same start date, the slope/linest
functions consider empty cells as part of the sample, and give me a wrong
result. Is there a way to force the functions to take into account only the
common data sets ?