Hi

i have
column a random descriptions (some recuring)
column b amounts corresponding to a descriptions


for example
1 aaa 1
2 bbb 1
3 aaa 1
4 aaa 2
5 bbb 1
6 ccc 1
7 ccc 1
8 ddd 1
9 eee 1
10 aaa 1


what i need is to somehow get

l and m

1 aaa 5
2 bbb 2
3 ccc 2
4 ddd 1

I used the advanced filter option. problem now is if i edit the list in column a and b it does not alter/edit the L and M columns

can email sample if not understood