SQUIDD
Well-known Member
- Joined
- Jan 2, 2009
- Messages
- 2,104
- Office Version
- 2019
- 2016
- Platform
- Windows
Hi
Strange one here.
I want to delete duplicates in a column, but keep the one whos date is the most up to date, for example
I have only 2 column of data. column A and column B.
1000 : 02/02/17
1001 : 02/02/17
1002 : 02/02/17
1003 : 01/02/17
1004 : 01/02/17
1002 : 01/02/17
so as you can see, i have in column A a duplicate, 1002, one has a date of 02/02/17 and one has a date of 01/02/17.
so i would like to end up with the oldest date removed. like
1000 : 02/02/17
1001 : 02/02/17
1002 : 02/02/17
1003 : 01/02/17
1004 : 01/02/17
at the most my column will be 100 rows long and have a max number of duplicates of 5.
But i really dont know how to go about achieving this.
Thanks for looking
Dave
Strange one here.
I want to delete duplicates in a column, but keep the one whos date is the most up to date, for example
I have only 2 column of data. column A and column B.
1000 : 02/02/17
1001 : 02/02/17
1002 : 02/02/17
1003 : 01/02/17
1004 : 01/02/17
1002 : 01/02/17
so as you can see, i have in column A a duplicate, 1002, one has a date of 02/02/17 and one has a date of 01/02/17.
so i would like to end up with the oldest date removed. like
1000 : 02/02/17
1001 : 02/02/17
1002 : 02/02/17
1003 : 01/02/17
1004 : 01/02/17
at the most my column will be 100 rows long and have a max number of duplicates of 5.
But i really dont know how to go about achieving this.
Thanks for looking
Dave
Last edited: