• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. F

    Help: I want to identify the latest date of my daily series

    Yes, this works!! Thanks a lot Hui
  2. F

    Help: I want to identify the latest date of my daily series

    Dear all: I want to identify the latest date of my daily attached series. If I use this formula = OFFSET(A1, COUNT(A2:A65536), 0) or OFFSET(A1, COUNT(B2:A65536), 0), I do not get the answer that I want So can any one help me with a formula that give me the 15-Jan-10 as the answer of my...
  3. F

    How to identify the lastest date of this daily series ?

    I used to use this formlua to identify the latest date of a monthly series : OFFSET('worksheetx'!A$3, COUNT('worksheetx'!B$5:B$10000), 0) but the formula above went wrong when I tried to identify this daily series: Date Agricuture 9-Nov-09 1,742 10-Nov-09 1,736 11-Nov-09 1,755...
  4. F

    How to identify the lastest date of the filled cell?

    Hi Hui. Your formula works for my first series but do you have any solution for the second type? date Jun-09 Jul-09 Aug-09 Sep-09 Oct-09 Nov-09 Dec-09 Jan-10 Feb-10 Mar-10 cpi 97.8 95.2 95.1 94.8 93.2 93.8 #N/A #N/A #N/A #N/A thank you so much
  5. F

    How to identify the lastest date of the filled cell?

    I have this series: date cpi Jan-09 102 Feb-09 90.5 Mar-09 92.4 Apr-09 95.5 May-09 96.8 Jun-09 97.8 Jul-09 95.2 Aug-09 95.1 Sep-09 94.8 Oct-09 93.2 Nov-09 93.8 Dec-09 #N/A Jan-10 #N/A Feb-10 #N/A Mar-10 #N/A Apr-10 #N/A May-10 #N/A Jun-10 #N/A and this date Jun-09 Jul-09...
Back
Top