If range isblank offset?

  • Thread starter Thread starter Adam
  • Start date Start date
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
 
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?
 
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.
 
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.
 
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
 
Back
Top