Hello to everyone, i have a .xls file as
A B
4 5
4 6
4 8
6 6
6 1
6 2
6 5
6 9
11 1
11 6
11 5
11 7
12 4
12 6

I need to subtotal column B based on Column A but I dont want "4
Total", "6 Total" or "11 Total"
What I require is
4 19
6 23
11 19
12 10

Is there any way to do this
Please help