HELP to edit a complex dynamic array formula for unique records from specific headers

Hi All

Need to edit a complex dynamic array formula to have unique records for specific headers from a database(20000 rows of data) original data (dummy)

First I have obtained this formula from a blog and am not well acquainted with to edit it.

See annexed sheet blog formula as the original formula has been written to have a clear view

I do think there is a concatenation required from header A to F with ampersand and match in the formula.

Target aim the whole row headers A TO F only should have unique records on dynamic sheet as annexed


Thanks those who can help to adjust formula,macros are also welcome.

ok the original datasheet is a database with lot of data


my concern is from COLUMN A TO F, the other is irrelevant to send to specific parties .

Column A,B,C AND F are always the same but column D AND E ,the data change dynamically following tests.

Thus my expectation is to have a dynamic unique records row list. as shown on dynamic sort sheet. with the number of count records.

So on a blog I have copy a sample of this formula to apply column C unique description as seen sample blog sheet with formula in column c but it applies only to one column only

So I would like to adjust same formula on dynamic sort sheet for column A TO F taking the data from original data column A TO F.

IN essence,have unique row records of column A TO F of original data sheet into dynamic sort sheet.

Why because the database changes every hour. so I have to maintain unique records and sent to other parties with only requested data as other data are sensitive.

Thanks if you could help

Hi

Excellent thanks for this marvelous solution