Hi guys,

If column A has the same value as the previous line and the sum of column B is less than 3 I want that group to have unique number in column C for that group.

Please see attached file.. hard to explain this

Br,
Mikael

Col A Col B Col C
A 1 ABC123
A 2 ABC123
A 3 ABC123

A 1 SSD111

B 1 ABC456
B 2 ABC456

C 1 DDD
D 1 DDD11
D 2 DDD11
D 3 DDD11
help.xlsxhelp.xlsx
D 1 TEST1
D 2 TEST1
D 3 TEST1

D 1 TEST2
D 2 TEST2
D 3 TEST2

D 1 TEST33
D 2 TEST33