Hello,
How can I find duplicate rows from columns A through E. Then sum the values in column F of these duplicates?
Additionally, If the row is unique just copy over the entire row.
In this example, row 2 column A through E is unique. So the entire row A through F is copied over to the right hand side.
Rows 3 through, 7 columns A to E are duplicates. So, sum the values in column F and place the result in the next row on the right hand side.
Any assistance would be greatly appreciated.
Thanks,
How can I find duplicate rows from columns A through E. Then sum the values in column F of these duplicates?
Additionally, If the row is unique just copy over the entire row.
In this example, row 2 column A through E is unique. So the entire row A through F is copied over to the right hand side.
Rows 3 through, 7 columns A to E are duplicates. So, sum the values in column F and place the result in the next row on the right hand side.
Any assistance would be greatly appreciated.
Thanks,