Help: Combining a column reference with a number calculated in a cell

Hi,

I'm trying to find out how to combine a column with a number that I have calculated. For example, I have a formula which works out the length of the column which is:

=LOOKUP(2,1/(B:B<>""),ROW(B:B))

Which in this example outputs 1792 in cell I7

I now want to be able to plot into a line graph something like this C3:C (and the value of) I7

I've got a lot of graphs to make and so automating this with a macro would save me a lot of time but the issue is that the number of rows is always changing and I always want to start from C3

I hope this makes sense. I'd really appreciate it if anyone could help me with this

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

For anyone helping with this, the formula is in F35, not F7.

Try named ranges:

e.g Named Range .... CH4_d_ppm

=OFFSET('Excel Forum Help doc'!$F$3,,,COUNTIF('Excel Forum Help doc'!$F$3:$F$100,"<>"),1)