Hello JLGWhiz,

Thank you for your help!

In my worksheet beginning with A4,
if B4 = B5 Then A4 = 1
if B5 = B6 Then A5 = 2
if B6 isBlank Then A6 isBlank
if B7 isNotEqual to B8 then A7 = 1
if B8 isNotEqual to B9 then A8 = 1
if B9 = B10 Then A9 = 2
if B10 = B11 Then A10 = 3

Thank you for your help,
jfcby