How to identify consecutive values?

[Jenis]

Hi,

I want to identify when the product column has 3 consecutive values or more. If the values is less than 3 consecutive values then the output should be false . I'm not sure how to get this type of output. Any help will be appreciated.

ID	Product	Max_Consec	Output
101	1	3	Consecutive
101	2	3	Consecutive
101	3	3	Consecutive
101	1	3	FALSE
101	2	3	FALSE
102	1	5	FALSE
102	1	5	FALSE
102	1	5	FALSE
102	1	5	Consecutive
102	2	5	Consecutive
102	3	5	Consecutive
102	4	5	Consecutive
102	5	5	Consecutive
103	1	4	Consecutive
103	2	4	Consecutive
103	3	4	Consecutive
103	4	4	Consecutive
103	1	4	Consecutive
103	2	4	Consecutive
103	3	4	Consecutive

[growexx]

Hi Jenis,

As per my understanding You can use Multi row formula or IF Function to derive the output!