I am looking for formula that will calculate the Date Value in the column header for the last value (going left to right) NOT EQUAL to 0 in a row. For example, in the attached sample file, I have Date Values in row 1 (C1:V1) which range from Jan-13 to Aug-14. The data below shows the revenue generated per Client by month. For each row (Client), I am trying to calculate when the last month when any revenue was generated and put the value in column W. The attached example should provide a good sample of what I am trying to do. Thank you in advance and let me know if you have any ?'s.
Ozgrid Pre-payment has been sent.