Worksheet version of VBA JOIN

  • Thread starter Thread starter Lawrence
  • Start date Start date
L

Lawrence

Can anybody help me create a 'join' between to non-contiguous ranges
to feed into 'Slope'?

I saw another question about this on this forum BUT my problem is that
the ranges are variable, using offset, rather than fixed.

Want I want to do is:

Slope(join(offset(a10,0,0,1,a1),offset(b10,0,0,1,b1)),'known_x's etc)

Any help appreciated,

Lawrence
 
Actually Patrick I want a worksheet version... not VBA

Thanks for your help though,

Lawrence
 
Back
Top