Hello,
I have created a dynamic name range called "Data".
It contains the following offset formula: =OFFSET('2019 Data'!$D$2,1,0,COUNTA('2019 Data'!$D:$D)-2,4)
I would like to combine a percentage formula the "Data" range So that my empty fields calculate through a range:
A B C
1 Sales 1 sales 3 sales 3
=b1/a1-1(Data) is not working out. Please help
Bookmarks