₦airaland Forum

Hi,
Would someone kindly assist me with MS excell formula. I need to sum up the amount for diffent accounts that belong to one ID number. I need to display the duplicating ID numbers together with their different account numbers.

ID Number Account Oustanding amount
2222222222222 2077777745 172.76
2222222222222 2088666669 168.67
4444444444444 1086660696 46
4444444444444 1084217333 135.68
8888888888888 1000005441 120.12
8888888888888 1087882188 285.08
8888888888888 2034512345 400.5
8888888888888 5007891011 257.6


thanks in anticipation.

Rrase