Hello,
I am creating a named dynamic range for a chart to dynamically update as values are automatically populated based on a date.
I am using the following formula:
=OFFSET('Chart Data'!$B$1,1,0,COUNTA('Chart Data'!$B:$B)-1,1)
this is my data as of now:
[TABLE="width: 500"]
[TABLE="width: 287"]
Date
[/td]Audits (Cumulative)
[/td]6/1
[/td]
[TD="align: right"]158
6/2
[/td]
[TD="align: right"]381[/TD]
6/3
[/td]
[TD="align: right"]554[/TD]
6/4
[/td]
[TD="align: right"]554[/TD]
6/5
[/td]
[TD="align: right"]554[/TD]
6/6
[/td]
[TD="align: right"]730[/TD]
6/7
[/td]
[TD="align: right"]761[/TD]
6/8
[/td]
[TD="align: right"]761[/TD]
6/9
[/td]
[TD="align: right"]761[/TD]
6/10
[/td]6/11
[/td]6/12
[/td]6/13
[/td]6/14
[/td]6/15
[/td]6/16
[/td]6/17
[/td]6/18
[/td]6/19
[/td]6/20
[/td]6/21
[/td]6/22
[/td]6/23
[/td]6/24
[/td]6/25
[/td]6/26
[/td]6/27
[/td]6/28
[/td]6/29
[/td]6/30
[/td]
[/TABLE]
[/TD]
[/TABLE]
the blank cells in column B equal "". I want to omit the "" cells in the count A for my heighth in the above formula
let me know if I need any further clarification on this.
thank you for the help!