Hi,
I have a spreadsheet that contains two columns, hotel and date.
What I wanted to do was only keep the entry that has the latest date, and delete the duplicates.
For example:
Hotel Date
123 1/01/2016
123 2/01/2016
123 3/01/2016
abc 5/01/2016
abc 6/01/2016
abc 7/01/2016
would look like
Hotel Date
123 3/01/2016
abc 7/01/2016
please advise!
so you want last date for each hotel
Sort by date (Newest-Oldest)
remove duplicates based on (hotel)
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Enter formula in E2 and copy down
Formula:
Please Login or Register to view this content.
Hotel Date
Sheet: Sheet3
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Here is a two step solution. In D2 down and over to column E paste:In G2 down and over to column H paste this array formula (activate with Ctrl+Shift+Enter):
Please Login or Register to view this content.Here is your data with the formulas applied.Please Login or Register to view this content.
Condensed Hotel List.xlsx
Let me know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks