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!
You could use the Data, From Table button to remove the duplicates. Just control+click the three columns , click the Remove Rows drop-down and then select "Remove Duplicates". AFter that click the "Close & Load..." drop-down and choose "Close & Load to..." and set it to return a table on a new worksheet. Now make sure your dashboard formulas use this new table instead of the original.
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!