Hello,
I would like to know how I would automatically create a formula(s) to remove duplicate rows of data based on columns Completion Time, Today's Date,and Store Name. I want to also keep the lastest entry of the duplicate based on Completion Time.
In the image, I provided you can see that rows 10-11, 12-13, and 14-16 have duplicate entries for the day. I only want to keep the latest one that was entered based on Completion Time.
Thank you!
Bookmarks