Auto-updating charts
Hi again,
Am Mon, 12 Sep 2016 19:03:14 +0200 schrieb Claus Busch:
1) Name = x_Values
RefersTo: =OFFSET(Tabelle1!$A$1,MATCH(MAX(Tabelle1!$A:$A),Ta belle1!$A:$A,0)-1,,-26)
if it is possible that you have sometimes less than 26 weeks change the
forumula to:
=OFFSET(Tabelle1!$A$1,MATCH(MAX(Tabelle1!$A:$A),Ta belle1!$A:$A,0)-1,,-MIN(26,COUNTA(Tabelle1!$A:$A)-1))
Regards
Claus B.
--
Windows10
Office 2016
|