Posted to microsoft.public.excel.worksheet.functions
|
|
how to trigger data
Thanks; this is very helpful
"Ashish Mathur" wrote:
Hi,
Suppose the dates typed rightwards from C3 and then entry is like
1/1/2002,1/2/2002, 1/3/2002, 1/4/2002 and so on (till S3). In row 4, there
are numbers
In cell C8, enter =1/1/2003
In cell D8, enter
=INDEX($C$3:$S$4,2,MATCH(C8,C3:S3,0))/INDEX($C$3:$S$4,2,MATCH(DATE(YEAR(C8)-1,MONTH(C8),DAY(C8)),C3:S3,0))
This will give you the growth of 1/1/2003 over 1/1/2002
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"renegade" wrote in message
...
I have laid out a table containing 50 data on a monthly for a period of 5
years. I intend to calculate growth rate calculated over the same period
in
different years.
So Row 1 contains: Jan-02, Feb-02, Mar-02, ...Jan-03, Feb-03, ...
So the growth rate I intend to calculate would be Jan-03/Jan-02,
Jan-04/Jan-03, Feb-03/Feb-02, and so on... Is there a function which could
locate and trigger the right data and then calculate? Thanks!
|