Question on Filtering of multiple versions

[pieter1987]

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).

[TABLE="width: 500"]
<tbody>[TR]
[TD]Project[/TD]
[TD]Version[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]2.1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

Thank you very much in helping me out with this struggle.

Best Regards,

Pieter

 

[pieter1987]

Here's a link with your file and the desired result

https://we.tl/eDb6EuXoYK

If it still not working .. just let me know

You are a true excel genius thanks so much!

 

[sasha 99]

You are welcome