Someone could probably save me half a day with the right answer to this.
My goal is to make it as easy as possible for people to review a list of changes by only showing the pertinent rows.
I want to find all the rows that are total duplicates (in respect to two of the columns, but not the rest of the columns) and hide all but the first “level” of the duplicates. So if there is a row “Apples” with the description “Do this” at “Level 1” and “verson 1” and another row “Apples” with the description “Do this” at “Level 2” I only want to be able to show the level 1 version and filter the level 2 version. However, if there was a row “Apples” with the description “Do this, Do that” at “level 2” I want to show both the level 1 and level 2 rows since they are different.
I made a test doc to show what I’m after. Would greatly appreciate any help!