i have column E with downwards multiple entrys of wich some is repetetive in other words
e13 a
e14 b
e15 a
e16 c
e17 a
e18 b
e19 a
e20 c
e21 a
e22 b

and in g i have amounts thats corresponding/refering to E for example
g13 100
g14 101
g15 204
g16 20
g17 50
g18 10
g19 100
g20 101
g21 30
g22 47

i need in column L to only show

L13 a
L14 b
L15 c

and in column M i will need the sum of all the a's in M13 and sum of b's in M14 and sum of c's in M15 for example

M13 484
M14 158
M15 121

there will be on different sheets different amounts of rows so it could be on one sheet 23 unique items in column E and on another sheet 100 unique items

thank you!!!

can send sample of the workbook