If range isblank offset?

A

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

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?
 
A

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 -
Click to expand...

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

T. Valko

If(isblank(A2:L2),OFFSET??
I need to know the right most data then offset it by -2 rows
Click to expand...

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 -
Click to expand...

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.
 
C

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
 
Top