| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel equation question
How can you use the( =small) equation using dates with cells that have a
zero. I want the equation to ingnore cells with zero and only look at cells with a date. i.e Last TRN Last Receipt Last Issue Last Ship 20080506 20080307 0 20080229 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel equation question
Use a COUNTIF() to count the zeros +1...as below
=SMALL(A1:A10,COUNTIF(A1:A10,0)+1) If this post helps click Yes --------------- Jacob Skaria "Jackie" wrote: How can you use the( =small) equation using dates with cells that have a zero. I want the equation to ingnore cells with zero and only look at cells with a date. i.e Last TRN Last Receipt Last Issue Last Ship 20080506 20080307 0 20080229 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Question about a new equation or function I am unfimiliar with | Excel Discussion (Misc queries) | |||
| value based on count (equation question) | Excel Discussion (Misc queries) | |||
| equation / function question | Excel Worksheet Functions | |||
| Linear Trendline Equation Question | Charts and Charting in Excel | |||
| Quick question: What does "--" in an equation do? | Excel Worksheet Functions | |||
Linear Mode
