Hello all i got 2 columns A and B , with random values in them.
I need in column C to put all of the values that appear in the column A with no repeat, and in column D to put the sum of all values in column B which correspond to the values of a column A. I need that to be formula conection, not advanced filter.
example
A B C D
1 3 1 4
2 5 2 12
3 6 3 8
2 7 4 10
1 1
4 6
3 2
4 4
Thank you this is very important to me, because i always have problem with advanced filter
I need in column C to put all of the values that appear in the column A with no repeat, and in column D to put the sum of all values in column B which correspond to the values of a column A. I need that to be formula conection, not advanced filter.
example
A B C D
1 3 1 4
2 5 2 12
3 6 3 8
2 7 4 10
1 1
4 6
3 2
4 4
Thank you this is very important to me, because i always have problem with advanced filter
Last edited: