If range isblank offset?

[Adam]

Hi All,
I have a row of titles Jan-Dec and a Total column. The row below this
has the data.
I want the total column to read the latest month where there is data
below it.

The only way I can see is an If(isblank(A2:L2),OFFSET??

Anyone have any ideas?

Many thanks,
Adam

 

[T. Valko]

The only way I can see is an If(isblank(A2:L2),OFFSET??

So, you want the rightmost entry in the range?

What type of data is in this range? Text? Numbers? Both? Any formulas that
return formula blanks?

 

[Adam]

So, you want the rightmost entry in the range?

What type of data is in this range? Text? Numbers? Both? Any formulas that
return formula blanks?

--
Biff
Microsoft Excel MVP









- Show quoted text -

Yes I need to know the right most data then offset it by -2 rows to
show the respective column. The data is numbers, the offset is date.

 

[T. Valko]

If(isblank(A2:L2),OFFSET??

I need to know the right most data then offset it by -2 rows

Ok, it sounds to me like you have dates as column headers in the range
A1:L1.

To return the date that corresponds to the rightmost numeric entry:

=IF(COUNT(A2:L2),LOOKUP(1E100,A2:L2,A1:L1),"")

Format as Date


--
Biff
Microsoft Excel MVP

So, you want the rightmost entry in the range?

What type of data is in this range? Text? Numbers? Both? Any formulas that
return formula blanks?

--
Biff
Microsoft Excel MVP









- Show quoted text -

Yes I need to know the right most data then offset it by -2 rows to
show the respective column. The data is numbers, the offset is date.

 

[CLR]

Cool, Biff.........works great!......
(I was almost there but my eyes rolled back in my head and I started
salavating and shaking, and the Nurse rushed in with my medication......)

Vaya con Dios,
Chuck, CABGx3

 

[T. Valko]

You're welcome, Chuck!