summe column depending of other columns

Hi
I have a problem :I want to create a macro that make the somme of 2 other columns when the nummer of the first column ist double(more than one ) and put the somme in a new Rows. like this :

A B
23 5
23 12
23 2
45 4
45 1
46 3

in the news the resultat in the same columns itīs like this

A B
23 19
45 5
46 3

Thanks for your comprehenssion

Try with this macro (it will put output data one row after last row):

Please Login or Register  to view this content.

Regards,
Antonio

Originally Posted by antoka05

Try with this macro (it will put output data one row after last row):

Please Login or Register  to view this content.

Regards,
Antonio

Thanks Antonio
But i dont want to go get the result in other row or columns , I want just they numbers stay in place and give the result .
Thanks

Try with this faster macro (it will put data in range 'a2' replacing old data. Please indicate your first free column in the first row because this code need two free column where sum data:

Please Login or Register  to view this content.

Regards,
Antonio

Originally Posted by antoka05

Try with this faster macro (it will put data in range 'a2' replacing old data. Please indicate your first free column in the first row because this code need two free column where sum data:

Please Login or Register  to view this content.

Regards,
Antonio

thanks Antonio
but I replace my first Columns ist "D" but it doesnīt works
thanks

Hi
i will like to make for 2 columns C und D , itīs possible ?

The macro apply advanced filter and do a unique copy of column 'A' in one free column you indicate (for example 'C'), then apply formula to next columns (for example 'D') to get sum for all unique data. At the end copy all data (for example from column 'C-D') to cell 'A2'.
You can indicate the column you want (except 'A' or 'B' where you have data to copy/sum).

Regards,
Antonio

Originally Posted by antoka05

The macro apply advanced filter and do a unique copy of column 'A' in one free column you indicate (for example 'C'), then apply formula to next columns (for example 'D') to get sum for all unique data. At the end copy all data (for example from column 'C-D') to cell 'A2'.
You can indicate the column you want (except 'A' or 'B' where you have data to copy/sum).

Regards,
Antonio

Thanks
I want to make at the same time A -C,D. the code can be change for that .Now i have only for one column ex : A-C , but now I want for A-C,D

You mean you have data in columns 'c' and 'd'? I'm sorry but I don't understand well what you need.

Regards,
Antonio