Sep 10 2019 02:32 PM
I am working with a large data set (12 columns with 45,000 rows of entries) which is updated each day which in turn auto-updates a dashboard (within the document on another sheet) I have created to analyze this data.
Currently, I am using the "remove duplicates" function to delete duplicates between three columns of my data set. I have attached a screenshot of the function:
This would be fine, however this function does not work with the new data that is added each day and I must I manually perform this function. Is there a way create a rule so that my sheet will always delete the duplicates between these three columns even when additional data is added?
Thank you for the help!
Note: I am also using =countifs & =sumifs in my "dashboard" table to count/sum things within a certain date range. If I can add something to my formulas to ALSO exclude duplicates with three criteria, this would be a good solution as well.
I apologize if this doesn't make sense, I would be happy to clarify!
Sep 11 2019 12:47 AM
Sep 11 2019 08:12 AM
@Jan Karel Pieterse ok great! I will give this a try. And this should be applied automatically to any additional data entered into the table? I really appreciate the response!
Sep 11 2019 08:19 AM
Hello @Jan Karel Pieterse! I do have a follow up question: is there a reason that I cannot/should not close and load to the default sheet? Will that impact any additional data entered? I will definitely play around with things though... I can't believe I have never seen this function through all of the excel classes I took in college! I'm very excited to learn more and am so grateful you pointed me in this direction!
Sep 11 2019 08:54 AM