Remove duplicate entries from a column, but keep the last non-empty cell when the value changes
For sake of clarity and ease of viewing, I only want a cell to be updated with a value if it’s value is changed from the previous value, otherwise have it blank (or an empty string "").
How to fix an old sheets spreadsheet and then future proof it so it doesn’t error out again with another google update [lookup(2/1…]
I have an old complex formula (worked years ago) that involves this part of a formula LOOKUP(2,1/($G$28:$G30<>"" that can be dragged down to extend in the same column. It’s supposed to only update the cell if it’s changed, otherwise it’s left blank. Unfortunately it doesn’t work anymore due to a Google Sheets update.