Excel formula to list out the info according to criterion

  • Thread starter wilchong via OfficeKB.com
  • Start date
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
 
D

Don Guillett

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.
 
W

wilchong via OfficeKB.com

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 said:
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
 
D

Don Guillett

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
wilchong via OfficeKB.com said:
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 said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top