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

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

 

[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