Forum Discussion
How to Remove Duplicates While Keeping Oldest Observation
Hi all. I am working with cross-sectional time series data and need to remove duplicate observations while keeping the oldest one. I was looking toward using the UNIQUE function but am unsure how to ...
Enter this formula in a new column.
=MINIFS([Date],[Line Item],[@[Line Item]])=[@Date]Filter the column on FALSE, select the rows and remove them.