• 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

    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...
  2. 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...
  3. 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