| 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 |
| 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 | |||
Threaded Mode
