You can get the detail arrays with something like

=IF((A2:A100=--"2005-11-01")*(A2:A100<=--"2005-11-30")*(B1:M1="Company1")),
B2:M100)

as an array formula

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sergun" wrote in message
...
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