| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to trigger data
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why won't target cell data changes trigger formula evaluation? | Excel Worksheet Functions | |||
| Trigger a Date & Time stamp by entering data in another field... | Excel Worksheet Functions | |||
| trigger data validation warning | Excel Discussion (Misc queries) | |||
| Trigger code if certian data is present | Excel Discussion (Misc queries) | |||
| trigger help | Excel Worksheet Functions | |||
Threaded Mode
