Range based on values

[Tina15]

Hi,

I have a series of data that is updated each month. The cells are formulas that feed from other worksheets.

so in February, the data looks like this:

A B C
Jan Feb Mar
25 32 -


then in March, when the data is updated, the formula in column C will return a value.

I would like to determine a range based on whether the cells have values (I don't want the cells with just the formulas only.) So at the end of Feb, my range would be A-B, and at the end of March the range would adjust to A-C. How do I do this?

Thanks in advance for your help!

[DonkeyOte]

It's not very clear what you intend to do with the range once found ?

In which rows do the values appear, row 2 ?

You can use:

=MATCH(9.99999999999999E+307,$2:$2)

to determine the last column containing a number if that's your wish ?

Your range would thus be: $A$2:INDEX($2:$2,MATCH(9.99999999999999E+307,$2:$2))

I would use the above in preference to any native OFFSET function