Hi! I have data in the following format:
[name] [type] [amount]
harry A $xx
harry A $xx
harry 4 $xx
harry 3 $xx
jen 3 $xx
jen 3 $xx
jen A $xx
I need to subtotal the amount column at each change in the type per employee. So from my example, I need the dollar sum for each type that "Harry" has.
I have been doing this manually for large files. There HAS to be an easier way with a function in excel.
Can anyone please help??????
Bookmarks