Getting unique list and amount sum by unique list wise - Reg.

Dear Forum

I am looking for the support of " Getting unique list and do amount sum option by unique list wise". Kindly refer the attachment.

Explaining data set:

1. Attachment has 2 sheets. 1st sheet is data set, which contains master data table (A:L column) and data extraction report (N:X column). Data extraction report has been framed with ARRAY formula. 2nd sheet is summary report table sheet.

2. my requirement is in the 2nd sheet only. i.e., summary report table. I want automatic summary table for data extraction report only, not for master data set.

I have given clear expected result with model data in the attachment (Sheet 2 : Summary Report sheet)

Thanks in advance.

Bala