Excel equation question

J

Jackie

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
 
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 problem 1
How do I install Microsoft Equation 3.0 back to Office 365? 0
How can i find the max value within a time range ased on two cells 6
Different Word 2016 equation editors 0
SumIf equation question 6
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5
Help on the Sumif Function 1
XIRR vs. IRR Function 11

Top