Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
correlation function in macro
hi there
can anyone help me in this ? in column A i have dates from jan 1990 till june 2003. in column B i have data for fund X in column C i have dta for fund Y i want the user to be asked to enter start and end date . and in column D based on that input i need to get the correlation between X and Y. i can use the correl function in excel to do that. is there a macro to do this ? thanks in advance. sam email : |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How many cells can a correlation function cover? | Excel Discussion (Misc queries) | |||
correlation function | Excel Discussion (Misc queries) | |||
correlation | Excel Worksheet Functions | |||
Correlation formula/function question. | Excel Worksheet Functions | |||
Correlation - Which Analytical Function to Use | Excel Discussion (Misc queries) |