$25 USD: Return Column Header Date Value of last value per row

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




    ozgrid.com/forum/core/index.php?attachment/62189/

  • Re: $25 USD: Return Column Header Date Value of last value per row


    Please try this formula in W2.


    [COLOR="#0000FF"]=IFERROR(LOOKUP(2,1/($C2:$V2<>0),$C$1:$V$1),"")[/COLOR]


    copied down

    Where there is a will there are many ways. Finding one that works for you is the challenge!


    MS Excel MVP 2010-2016