Find duplicates in excel and sum?

Help Activities
, ,
1

I want find duplicates for column A-G.
If duplicate sum data in column H as below.
data dup.xlsx (9.3 KB)

Input
image

I want output

image

Please guide me about it (VBA or UIPath)

2

Hi,

Hope the following helps you.

img20210625-2

Sample20210625-2.zip (10.5 KB)

Note: Name of ColumnD is modified to “Location code” due to same column name as columnB, in the above sample.

Regards,

3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.