Dear sir,
There are 3 data sets is assumed running in A1 down, viz.:
In A1 down to A5, are showing a set of date: from 1 to 5 (2007.01.31; 2007.09.
25; 2008.07.31; 2008.10.31 and 2009.05.31)
From B1 to B5, are showing a set of account number: 234; 314; 234; 314 and
234.
From C1 to C5, are showing a set of outstanding value of account number:
$100; $250; $70; $500 and $650.

In additional, in the cell of D1 is the beginning date (2007.01.01), whereas
D2 is the end date (2008.07.31).
In the cell of E1 is show the account number: 234

My question: I want to know how can I set an excel formula which I place in
D11 and list out the date of cell A1and A3 according to the criterion show in
the cell D1, D2 and E1 . I have tried to set up the formula as follow, but
failed:
{=IF(ROWS($1:1)COUNT(A$1:A1),"",INDEX($A$1:$A$10, SMALL(,ROWS($1:1))))}

Thanks for your advice,
Wilchong

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/201003/1