Excel equation problem

  • Thread starter Thread starter Jackie
  • Start date Start date
J

Jackie

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
 
Use a COUNTIF() to count the zeros +1...as below

=SMALL(A1:A10,COUNTIF(A1:A10,0)+1)

If this post helps click Yes
 
Back
Top