Hello Excel Pro...good day...found a dynamic trend line with a data set vertical as below:
a 50
b 29
c 67
d 46
e 69
f 48
g 46
h 64
i
j
***The offset formula is =OFFSET(Sheet1!$A$2,0,1,COUNT(Sheet1!$B:$B),1)
Now my question is what if the data is arrange horizontally as in below:
50 29 67 46 69 48 46 64
a b c d e f g h i j
***Any idea what would be the offset formula? Please help as I can't find the solution online....thanks
Probably not fully understood what you call a trendline, nevertheless if you just want similar calculations for horizontally arranged data try:
Formula:
=OFFSET(Sheet1!$B$1,1,0,1,COUNT(Sheet1!$2:$2))
the formula in your post seems to be tailored for situation with headers in row 1, so mine includes headers in column A.
Best Regards,
Kaper
May be this
=OFFSET(Sheet1!$B$2,-1,0,1,COUNT(Sheet1!$1:$1))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks