Getting the particular value on the basis of given criteria ?

[Luqman]

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

 

[Thyagaraj]

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 - Sort the date column Ascending

Regards
Thyagaraj

 

[bplumhoff]

Hello,

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

HTH,
Bernd