View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Luqman Luqman is offline
external usenet poster
 
Posts: 8
Default 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