View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Find the Longest Run.

Which I got using the countmax UDF


Gord

On Wed, 10 Oct 2007 17:39:49 -0400, "T. Valko" wrote:

Based on your sample data I get:

=0 = 5

<0 = 3