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

How to identify the lastest date of this daily series ?

fitfat

New Member
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

12-Nov-09 1,738

13-Nov-09 1,760

14-Nov-09 #N/A

15-Nov-09 #N/A

16-Nov-09 1,793

17-Nov-09 1,778

18-Nov-09 1,790

19-Nov-09 1,790

20-Nov-09 1,787

#N/A #N/A

#N/A #N/A

#N/A #N/A

#N/A #N/A

#N/A #N/A

#N/A #N/A

#N/A #N/A

#N/A #N/A

#N/A #N/A

#N/A #N/A

#N/A #N/A

#N/A #N/A


I suspect the problem is beacuse the formula confuse with the NA before 20-Nov-09.


Does any one can help me on this?
 
If column A has dates without #N/A in between, use this formula instead,


OFFSET('worksheetx'!A$3, COUNT('worksheetx'!A$5:A$10000), 0)
 
Back
Top