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. 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!
Currently, I am using the "remove duplicates" function to delete duplicates between three columns of my data set. 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!
