ExcelBanter - Excel equation question

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel equation question (https://www.excelbanter.com/excel-worksheet-functions/239775-excel-equation-question.html)

Jackie

Excel equation question

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

Jacob Skaria

Excel equation question

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 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

All times are GMT +1. The time now is 10:09 AM.