If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|