View Single Post
  #1   Report Post  
Sam via OfficeKB.com
 
Posts: n/a
Default Count Consecutive Numbers in a Row

Hi All,

Can anyone help me with a Formula to COUNT how many numbers are consecutive
within a Row that spans 10 Columns?

Example:
65 67 68 69 75 79 80 84 85 90

The answer to the above example should be a Count of 7.

Much appreciated.

Regards,
Sam

--
Message posted via http://www.officekb.com