W
wilchong via OfficeKB.com
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
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