Hi,
I have a dynamic array, like this:
14.11.2018 A B C 15.11.2018 A B C 16.11.2018 D E F 17.11.2018 D E F 20.11.2018 G H I
The table contains duplicates relative to columns B, C and D, but the dates in column A for those duplicates will differ. For each set of duplicate rows with regards to columns B, C and D, I need to filter out duplicates and keep only the row within each duplicate set which contain the lowest value in column A for the set.
The resulting table will then look something like this:
14.11.2018 A B C 16.11.2018 D E F 20.11.2018 G H I
Does anybody have a dynamic array solution to this? Please see attached workbook.
Best regards,
Marbleking
Bookmarks