Hello guys,
I have a new project where I would like excel to autofill in the third column the sum of the second column when the value in the first column is the same.
i.e. When the value is A, the third column to get the sum of all the previous values of column B.
The different values in column A are thousands.
Is it possible? Is it possible also MS Access to do the same?
Many thanks
I have a new project where I would like excel to autofill in the third column the sum of the second column when the value in the first column is the same.
i.e. When the value is A, the third column to get the sum of all the previous values of column B.
The different values in column A are thousands.
Is it possible? Is it possible also MS Access to do the same?
Many thanks
Values | Values | Auto Fill |
A | 1 | 1 |
A | 0 | 1 |
B | 1 | 1 |
B | 0 | 1 |
A | 0 | 1 |
A | 1 | 2 |
C | 1 | 1 |
C | 0 | 1 |
A | 1 | 3 |
B | 0 | 1 |
B | 0 | 1 |
C | 1 | 2 |
C | 1 | 3 |
C | 0 | 3 |