So I have a excel file where Column AA is Reference No, AB is Commission Amt and AD is Customer name. Now for AA reference no U326165744, I have to make Column AB sum of (41.18+5.35+0) because there column AD Customer name (LARA) is same. Also for Reference U946536964 it should sum (10.44+0) based on Column AD SIGMA (not 0.52 coz its SIGMA2)How would we do that in AA?
@Isaa Bella If you can get list/table of distinct Customer Name and their corresponding Reference, then
Hope this may help!