Forum Discussion
Data sort and Deletion
I am having trouble sorting this dataset and then deleting some data. Column C lists unique ID numbers, and column D is the data collection date. This database allows us to track data over time. ...
Not sure why you would have issues deleting the rows unless you are pulling data from a read only data source. But you could add a formula in column M to identify what to keep and delete with this formula
=IF(SUMPRODUCT((C$2:C$100=C2)*(E$2:E$100=E2)*(D$2:D$100>D2))+1=1, "Keep", IF(SUMPRODUCT((C$2:C$100=C2)*(E$2:E$100=E2)*(D$2:D$100>D2))+1=2, "Delete", ""))
You want to consider Column E as well since it appears to be unique.