| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting a range of values for another function
Hi,
I cannot seem to figure this one out... I have a table that contains e.g.: Company1 Company2 Company3 Date1 Value11 Value21 Date2 Value12 Value22 Date3 Value13 Value23 etc... For a function e.g. COVAR i want to select the values that are between GivenDate1 and GivenDate1-30, for a certain company. The results should be placed into following table: Company1 GivenDate1 COVAR GivenDate2 COVAR Company2 GivenDate1 COVAR GivenDate2 COVAR How on earth should I tackle this? Any help would be really appreciated. gr. Sergiy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
| Cell linked to a range of cell values in different sheet | Excel Discussion (Misc queries) | |||
| Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
| clock | Excel Worksheet Functions | |||
| How many values appear more than once in a range? | Excel Worksheet Functions | |||
Threaded Mode
