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