S sambit Member Nov 12, 2018 #1 Sir, plz help to resolve the issue. Enclosed example file for your information. Attachments Example.xlsx 10 KB · Views: 6
B bosco_yip Excel Ninja Nov 12, 2018 #2 Maybe.......... F5, copied down : =AGGREGATE(14,6,F$5:F$21/(E$5:E$21=E5),1) Regards Bosco Last edited: Nov 12, 2018