Custom function not giving desired result

[S. Das]

I have two custom functions which can do the same task one is given by @John Jairo V (Function Name: GroupA) and another is given by @p45cal (Function Name: GroupN).

The problem of GroupA function is solved by using GroupN.
Reference Link: https://chandoo.org/forum/threads/custom-function-not-updating-properly.36866/.

But GroupN has some problem, it does not show the correct result in my worksheet, although except the attached worksheet it is perfectly alright.

I am attaching the worksheet here. Check Sheet2 and column G.

Thanks to all in advance.

 

[S. Das]

Help me.....

 

[bosco_yip]

Duplicated-post