Excel formula to list out the info according to criterion
 

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

Excel formula to list out the info according to criterion
 

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"wilchong via OfficeKB.com" <u43231@uwe wrote in message
news:a585751b1a3d4@uwe...
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

Excel formula to list out the info according to criterion
 

Dear Don,
Do you mean send you the excel file to your email address? But I cannot find
your email address so far!

Thanks for your help,
Wilchong

Don Guillett wrote:
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

Dear sir,
There are 3 data sets is assumed running in A1 down, viz.:
[quoted text clipped - 22 lines]
Thanks for your advice,
Wilchong

--
Message posted via http://www.officekb.com

Excel formula to list out the info according to criterion
 

My email address is right under my signature.....................

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"wilchong via OfficeKB.com" <u43231@uwe wrote in message
news:a591110785211@uwe...
Dear Don,
Do you mean send you the excel file to your email address? But I cannot
find
your email address so far!

Thanks for your help,
Wilchong

Don Guillett wrote:
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

Dear sir,
There are 3 data sets is assumed running in A1 down, viz.:
[quoted text clipped - 22 lines]
Thanks for your advice,
Wilchong

--
Message posted via http://www.officekb.com