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

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.

Getting the particular value on the basis of given criteria ?
 

Hello,

array-enter (CTRL + SHIFT + ENTER)
=MAX(IF(B1:B170,A1:A17))

HTH,
Bernd