Hi everyone, im sure this problem has been solved somewhere but i can't find it so im posting here.
I have a data dump that consists of unique ID's and their statuses. I run this every week and dump it below the previous weeks in the same sheet. I'm looking for a formula that can note if a change has occurred in status from the previous weeks entry based on the unique ID's. Entries in this database don't get deleted, only added. I want to avoid array formulas for computing power reasons.
Bookmarks