Excel equation problem

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
 
J

Jacob Skaria

Use a COUNTIF() to count the zeros +1...as below

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

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel equation question 1
Finding asymptote equation and how to draw them in excel 0
How do I install Microsoft Equation 3.0 back to Office 365? 0
2 Formulas needed!!! :) 13
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5
Equation Editor & Excel 2
XIRR vs. IRR Function 11
Need help with a formula 3

Top