Create automatically a range from the intersectionS of 2 ranges

Hi!

Is it possible to create automatically a new range from the intersections of 2 ranges ? Is there a function/any trick for that?

Thanks!
lo

Hello Ron!

Thanks for your answer.

But it did not help. My question was not precise enough.

Here is what I would like to do:

As you see in the example (see enclosed files), for each date, there is an Inflow EC value and an outflow EC value.

I would like to plot the evolution of the Inflow EC values within time in a chart and in an other one the evolution of the Outflow EC values. And I would like to have charts which can update update automatically as new data are added.

I could do everything manually by selecting the cells which have to be taken into account, but that's a lot of work (in reality I have much much more data).

I could also change the sheet structure by making the data contiguous and then use a dynamic range to get charts which can update automatically. But again I have a lot of data and it would be perfect if I could avoid doing this.

So I was thinking, maybe it's possible to do so:
I plot the chart "Evolution of the inflow EC values" by using the ranges "Date" (range made of all dates in the sheet) and "INFLOW_EC".

"INFLOW_EC" would be a range automatically made of every cells resulting from the intersection of the range "EC" (= the whole column in which the EC values are to be found) and the range "INFLOW" (all the rows in which the text "Inflow" appears).

And then for for the automatic update of the charts, i'll use something like OFFSET combined with any other functions...

Is it possible to do so? Do you have a better idea?

Thanks