| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel equation problem
How do I use the =small quation when using dates. I have some cells that have
a zero in them and do not want them count in the =small equation. I want it to tell me the oldest date excluding cells with a zero. i.e Last Trans. Last Ship Last Receipt 20080506 0 20070401 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel equation problem
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 do I use the =small quation when using dates. I have some cells that have a zero in them and do not want them count in the =small equation. I want it to tell me the oldest date excluding cells with a zero. i.e Last Trans. Last Ship Last Receipt 20080506 0 20070401 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) | |||
| Problem with Equation Display | Excel Discussion (Misc queries) | |||
| Averaging/Rounding Equation problem | Excel Discussion (Misc queries) | |||
| Equation setup problem | Excel Discussion (Misc queries) | |||
| equation problem | Excel Worksheet Functions | |||
Hybrid Mode
