How to not carry on duplicates from one worksheet to next?

[kinkart]

Hello,

I have this spreadsheet that use a pivot table to sort out my data by type (item) and displays them from their highest value to the lowest.

Manually, I copy all these tables, paste them in another worksheet, use a conditional formatting to highlight the duplicates and then, starting from the rightmost column, delete these duplicate until I have only unique items.

The file attached was create to better explain (3 tabs). It is important that there is priority between each item type (item 1 then item 2 then item 3 ...) and so that's why I delete duplicates first from the rightmost column.

I was wondering if there was any way to do so automatically, without using macros.
Any ideas?

 

[NARAYANK991]

Hi ,

See the file now.

This will work only if there are no duplicates within a list.

Narayan

 

[kinkart]

This is awesome, thank you so much Narayan.
When you get the chance, could you explain how this works, so that I can easily update it as more data comes in?

 

[NARAYANK991]

Hi ,

The problem is not so complicated because there are no duplicates within a list ; there are duplicates because the entries in any one list may occur in the other lists.

As far as the first list is concerned , there is no problem ; we just reproduce the list as it is.

For the second list , we need to check whether any item in the list occurs in the first one ; for the third we need to check whether any item occurs in either the first or the second ; for the fourth list , we need to check each item against the first three lists , and so on.

Checking the occurrence of an item in a list is done by the COUNTIF function. If an item does not occur in any of the other lists , COUNTIF will return 0.

Narayan