Forum Discussion
Solved
Remove duplicate rows and keep most recent year
Hi everyone,
When I try to remove remove duplicates row, the highest year is deleted, in this case 2025. I wish that the most recent year is always kept, and the other ones deleted.
P.S: I already saw similar solved posts with this issue, but I still have trouble finding the right way to resolve this issue.
Could you please help me?
Many thanks!
Current table
| Vendor Number | Year |
| 21400799 | 2023 |
| 21401540 | 2021 |
| 21401224 | 2022 |
| 21400799 | 2025 |
| 21400196 | 2022 |
| 998 | 2021 |
Expected result:
| Vendor Number | Year |
| 21401540 | 2021 |
| 21401224 | 2022 |
| 21400799 | 2025 |
| 21400196 | 2022 |
| 998 | 2021 |
Consider using the query editor this way: I grouped the data by specific criteria.
1 Reply
Consider using the query editor this way: I grouped the data by specific criteria.