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. However, I am working on a dashboard and only want to display the most recent data. For each collection data, there are 6 possible disability answers. I need to keep the most recent 6 for each ID number and would like to delete the rest. Does anyone have a suggestion on if it is possible to do this with a formula or some other way?
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.
