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!