Formula searching non-blank values in chart

[pezalmendra]

Dear all,

I have a chart which searches the values in a range from C to TZ.
The main challenge is that this range is not always full with values; sometimes values goes to range C:BZ, sometimes to C:CF, and so on. But the whole searching range is C:TZ

Q: is there a way of putting this requirements into the chart formula?

I have attached and example.

Thanks.

Kind regards

[tim201110]

user defined names for dynamic ranges
and clear "empty cells"

[pezalmendra]

Thanks tim!
Solved, much appreciated!

Kind regards