View Single Post
  #1   Report Post  
sd
 
Posts: n/a
Default formula to determine the first column containing any data

I have columns of data starting from Jan 2002 thru Sep 04 (33 columns)
Data contains numbers or are blank
Is there any formula (other than a VBA) that can determine against each row
the last month I had any number
Example:-

Jan-00 feb-00 mar-00 apr-00 may-00
50 12

The result should be Feb-00 as that month is the last time when I had a
data (and not blank) looking from right to left.
Just the formula to determine the column # will suffice, using offset I can
determine the month.