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. ...
Do you really want to delete data, or would it be OK to display the6 most recent results for each ID elsewhere? If the former, you'd need VBA. If the latter, you can use a FILTER formula.