I have a large sheet of customer data something similar to below (example1). I want to quickly format the sheet so that in cloumn A I only see the single customer ID with the total value of their orders in column B (example 2). Is there a quick way to do this withouht having to create a sum formula for each customer?
EXAMPLE 1
Column A Column B
A 10
A 11
A 12
A 13
B 13
B 23
C 1
C 12
C 189
D 26
E 15
E 15
EXAMPLE 2
Column A Column B
A 46
B 36
C 202
D 26
E 30
Bookmarks