dev.devil.1983
New Member
Hi All,
I need help on the following :
I have an excel with duplicate rows(4 columns), with fifth column having some numbers. I need to identify all the duplicates rows and add up their numbers in first column. Such that only one unique row remains of each combination with the summed up value against it. Also, the solution needs to be in excel formula
eg :
Before:
col1 col2 col3 col4 col5
A B C D 4
A C D B 5
A B C D 3
A C D B 9
After:
col1 col2 col3 col4 col5
A B C D 7
A C D B 14
Thanks,
Dev
I need help on the following :
I have an excel with duplicate rows(4 columns), with fifth column having some numbers. I need to identify all the duplicates rows and add up their numbers in first column. Such that only one unique row remains of each combination with the summed up value against it. Also, the solution needs to be in excel formula
eg :
Before:
col1 col2 col3 col4 col5
A B C D 4
A C D B 5
A B C D 3
A C D B 9
After:
col1 col2 col3 col4 col5
A B C D 7
A C D B 14
Thanks,
Dev