Hello,
I'm struggling with removing duplicates based on criteria.
I want to delete all duplicates based on Task ID (column AA) with criteria of completed Date (column K)
Result would be delete all rows without completed date (column K) and leave rows with date info (column K)
In original file I have over 9000 rows
please check link as I couldn't attach file
https://ufile.io/prxey
I'm struggling with removing duplicates based on criteria.
I want to delete all duplicates based on Task ID (column AA) with criteria of completed Date (column K)
Result would be delete all rows without completed date (column K) and leave rows with date info (column K)
In original file I have over 9000 rows
please check link as I couldn't attach file
https://ufile.io/prxey