I have a spreadsheet that contains ranges and from the range name I have MovingAvg:
=OFFSET(Data!$C$2100,1,0,COUNTA(Data!$B$2101:$B$65536),1)
currently the entries are at B3200. from C3195 down there are no average values. I other words the average values are not filling in when an entry occurs in the B column. How can I get values to start populating again.
Attached is an image of the name Manager. The other ranges appear to be working fine.
Range not executing
-
bknight
- BronzeLounger
- Posts: 1504
- Joined: 08 Jul 2016, 18:53
Range not executing
You do not have the required permissions to view the files attached to this post.
Last edited by HansV on 05 Aug 2024, 18:48, edited 1 time in total.
Reason: bot > not
Reason: bot > not
-
HansV
- Administrator
- Posts: 79321
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
bknight
- BronzeLounger
- Posts: 1504
- Joined: 08 Jul 2016, 18:53
Re: Range not executing
Data!$B$2101:$B$65536
-
HansV
- Administrator
- Posts: 79321
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Range not executing
I don't understand what you mean by "from C3195 down there are no average values."
Could you attach a copy of the workbook?
Could you attach a copy of the workbook?
Best wishes,
Hans
Hans
-
bknight
- BronzeLounger
- Posts: 1504
- Joined: 08 Jul 2016, 18:53
Re: Range not executing
Because column C has the averages of column B.