View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jackie Jackie is offline
external usenet poster
 
Posts: 78
Default 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