ExcelBanter - Excel equation problem

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

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

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

Jackie

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

Jacob Skaria

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

All times are GMT +1. The time now is 01:20 PM.