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
Bookmarks