Hi,
Is there any way to get some part of the range to use in some formulas like SLOPE?
If I have a range, for example, A1:A500, is it possible to get somehow only first element and the last 20, so it forms the range of only 21 elements?
=SomeFormula(A1:A500) and it returns only A1 and A480:A500, not using vba.
Bookmarks