View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dlbeiler dlbeiler is offline
external usenet poster
 
Posts: 14
Default Find the Longest Run.

I have a column of random numbers that are conditionally formatted for the
font to be blue if the number is = 0 and red if <0. How do I find the
longest run of numbers that are = than 0 and the longest run that are < 0
within the column.