Discrepancy in dynamic formula for unique records amendment required in formula

Can you explain what you mean when you say you used autofilter to obtain the results in columns K:M.

Clearly whatever you have done has not resulted in unique records.

The reason I asked is because I don't understand how you produced the K:M list by using Autofilter on A:C.
In any case Autofilter as far as I'm aware does not have an option to list unique items hence I'm trying to understand the steps you took to produce the list in K:M. It's neither a unique list nor a complete list.

And I disagree. The formulae in E:G ARE giving you a unique list of H codes.

If you are wanting a unique list of the Hcode, Description and Origin combined then you need to create a helper column which concatenates A,B & C cells and then use the helper column to filter a unique list using either your formula or a Data ADVANCED (not Auto) filter whereby you can specify UNIQUE.

I think you may need to define what YOU mean constitutes a UNIQUE item.

I understand what you mean. The combination of all three columns constituting 1 record must be unique.
If you concatenate columns A B and C in column D and use the following to extract the unique concatenated values. This will give a list of unique values.
I entered this ARRAY formula (enter with Ctrl + Shift + Enter) in Q6 and filled down. (I left 4 blank rows to be used with the Advanced Filter for comparison)

Formula:

Please Login or Register  to view this content.

I then entered this formula in K6 and filled across and down to extract the unique records from columns A to C

Formula:

Please Login or Register  to view this content.

This gives identical records as retrieved by the Advanced Filter Unique records.
I think that the enclosed file should be self explanatory.

Thank you for the feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.