Sorry but I can't understand all the formula and replicate them in my file. Could you pls set it up for the new file I've attached. That's how my the actual file will look like.
As a reminder I want to remove all duplicates on column AC and AH and keep the row with 'EN' in column AN. If no 'EN' then any row can be kept.
Thanks again.
Bookmarks