Help needed to count duplicates but derived by a column of values

[RIC63]

HI


I wish I could count how many equal values there are in column I for each group of equal values found in column G and write the results to the related row 2/column. e.g.


In column G there is only one value 1 so in L2 a possible formula would return 0,


In column G there are three 2 values, among these three 2s are equal so in M2 a possible formula would return 2,


In column G there are five 3 values, among these there are no equal values so in N2 a possible formula would return 0,


and so on.


I would appreciate some help in finding one or more formulas to perform this check.


Thank you