I have a spreadsheet with one row per date. Each row has a current total A, there are different ways to either add or subtract a value from that total.
No other column except G (for A, the current total) contains any calculations. And each G cell just subtracts and adds to the previous value. For example G3
Since most of the rows do not affect A in any way I'd like to have a way of only seeing those rows that actually change A (marked below in example). It has to be easy and quick to switch between viewing all rows and only the lines where A is changed.
If it is possible I'd like to do it without introducing another column that indicates if the row should be seen or not. However, the most important thing is that it's quick to work with so that I can easily switch between all rows and those changing A. If could be a filter, a filter view, a separate or whatever.