pieter1987
New Member
- Joined
- Feb 13, 2018
- Messages
- 5
Hi,
I have a question. I have an excel file with a long list of projects with versions of this list and I want to delete or hide all projects but the latest version. Is there a way to do this?
Below an example of the type over versioning. The idea is that I want to have a filter that takes all rows containing Project A 2.1, Project B 3, Project C and Project D (there are multiple rows having Project A 2.1 but I want them all to be filtered out except the once with Project A2 or A1).
<tbody>
</tbody>
Thank you very much in helping me out with this struggle.
Best Regards,
Pieter
I have a question. I have an excel file with a long list of projects with versions of this list and I want to delete or hide all projects but the latest version. Is there a way to do this?
Below an example of the type over versioning. The idea is that I want to have a filter that takes all rows containing Project A 2.1, Project B 3, Project C and Project D (there are multiple rows having Project A 2.1 but I want them all to be filtered out except the once with Project A2 or A1).
Project | Version |
A | 1 |
A | 2 |
A | 2.1 |
B | 1 |
B | 2 |
B | 3 |
C | 1 |
D | 1 |
<tbody>
</tbody>
Thank you very much in helping me out with this struggle.
Best Regards,
Pieter