Paste below formula in Cell I2 with CSE and drag it
=IFERROR(INDEX($A$2:$A$23,MATCH(0,COUNTIF($I$1:I1, $A$2:$A$23),0)),"")
Paste below formula in Cell J2 and drag it down :
=IF($I2 <> "", SUMIF($A$2:$A$23,$I2,$B$2:$B$23),"")
Paste below formula in Cell K2 and drag it down :
=IF($I2 <> "", SUMIF($A$2:$A$23,$I2,$C$2:$C$23),"")
![]()
Bookmarks