Corp_exceller
New Member
- Joined
- Aug 7, 2022
- Messages
- 19
- Office Version
- 2013
- Platform
- Windows
Hi,
I have a sheet of data containing multiple rows of non distinct application numbers, and columns containing a date and time, which will be different per entry. This is a non distinct set of application numbers which I want to make distinct based on latest date.
*Note there are many other columns in the data set which don’t apply to the problem I’m trying to fix.
I want to identify the row which contains the latest date (for each application number) by putting either true false or any other two binary markings, so that I can filter on the ‘true’s, giving me a leaned out data set.
Anyone know how to do this? Thanks!
I have a sheet of data containing multiple rows of non distinct application numbers, and columns containing a date and time, which will be different per entry. This is a non distinct set of application numbers which I want to make distinct based on latest date.
*Note there are many other columns in the data set which don’t apply to the problem I’m trying to fix.
I want to identify the row which contains the latest date (for each application number) by putting either true false or any other two binary markings, so that I can filter on the ‘true’s, giving me a leaned out data set.
Anyone know how to do this? Thanks!