View Single Post
  #5   Report Post  
Michael Rekas
 
Posts: n/a
Default

Thanks Ken

I like it!

Regards

Michael

On Sat, 29 Jan 2005 15:14:22 -0000, "Ken Wright"
wrote:

=SMALL(IF(A1:A100,A1:A100),2) array entered using CTRL+SHIFT+ENTER will
ignore 0s and blanks