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"]

[tr][td]Date

[/td][td]Audits (Cumulative)

[/td][/tr][tr][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][td][/td][/tr][tr][td]6/11

[/td][td][/td][/tr][tr][td]6/12

[/td][td][/td][/tr][tr][td]6/13

[/td][td][/td][/tr][tr][td]6/14

[/td][td][/td][/tr][tr][td]6/15

[/td][td][/td][/tr][tr][td]6/16

[/td][td][/td][/tr][tr][td]6/17

[/td][td][/td][/tr][tr][td]6/18

[/td][td][/td][/tr][tr][td]6/19

[/td][td][/td][/tr][tr][td]6/20

[/td][td][/td][/tr][tr][td]6/21

[/td][td][/td][/tr][tr][td]6/22

[/td][td][/td][/tr][tr][td]6/23

[/td][td][/td][/tr][tr][td]6/24

[/td][td][/td][/tr][tr][td]6/25

[/td][td][/td][/tr][tr][td]6/26

[/td][td][/td][/tr][tr][td]6/27

[/td][td][/td][/tr][tr][td]6/28

[/td][td][/td][/tr][tr][td]6/29

[/td][td][/td][/tr][tr][td]6/30

[/td][td][/td][/tr]

[/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!