I use a spreadsheet to keep records of lottery results in the range(A:F)
exlucding the bonus ball.
I need a formula to tell me how many in the row are consecutive numbers
in the row and keep the answer in cell H-M

e.g.

A B C D E F H I J K L M
11 12 22 24 27 28 2-1-1-1-1
10 12 25 33 39 41 1-1-1-1-1-1

Thanks for the help.
Michael168



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/