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 |