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 |