| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting the particular value on the basis of given criteria ?
I have two columns, Date and Amount
I need to extract the Amount which is greater than Zero and the Last date. For example: What is the last Date, where Amount is Greater than Zero, Answer is : Date: 01/01/2002 and Amount : 3000 Here is the data. Date Amount 01/01/2000 2000 01/01/2001 1000 01/01/2002 3000 01/01/2003 0 01/01/2004 0 Any idea please ? Best Regards, Luqman |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Getting the particular value on the basis of given criteria ?
Luqman wrote: I have two columns, Date and Amount I need to extract the Amount which is greater than Zero and the Last date. For example: What is the last Date, where Amount is Greater than Zero, Answer is : Date: 01/01/2002 and Amount : 3000 Here is the data. Date Amount 01/01/2000 2000 01/01/2001 1000 01/01/2002 3000 01/01/2003 0 01/01/2004 0 Any idea please ? Best Regards, Luqman Dear Luqman, Try this 1 - Put a filter for both the columns. 2 - In amount column filter go to custom and select amount greater than 0. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Getting the particular value on the basis of given criteria ?
Hello,
array-enter (CTRL + SHIFT + ENTER) =MAX(IF(B1:B170,A1:A17)) HTH, Bernd |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUM ON BASIS OF FORAMAT | Excel Discussion (Misc queries) | |||
| sum of 2 Months basis | Excel Worksheet Functions | |||
| NPV on a Quaterly Basis | Excel Discussion (Misc queries) | |||
| Define Basis | Excel Worksheet Functions | |||
| Ranking on basis of 3 Parameters | Excel Worksheet Functions | |||
Linear Mode
