How to group data in Excel?

[ppr (Peter Preuss)]

Direct Link to Post with solution ist Here

Identify the Duplicates and sum the value

Hi, 1.I need to find the duplicate value in the “ID” column. so value 80 and 82 contains duplicates. From that i need to compare “key” column.If duplicate is there in the key column then i need to sum all the columns value. In this case 82 column as duplicate ID and also key column contains duplicate key so i need to sum and bring the value as [image] Input:test.xlsx (9.4 KB) [image] I need to find duplicate for ID and key column.if duplicates ID contains duplicate key.Then i need to sum…