This is really cool. Is there also a way to hide the duplicates? I have two lists I compare each week. But with those lists I also have a unique number linked to the names, as well as an email address. I’ve been trying to make one list of the duplicates, but then remove them from the original list. Each list is for client communication, and the duplicates require different communication than the remaining names.
❤ how to compare two pivot tables filtered, and count unique values
Thanks
This is really cool. Is there also a way to hide the duplicates?
I have two lists I compare each week. But with those lists I also have a unique number linked to the names, as well as an email address.
I’ve been trying to make one list of the duplicates, but then remove them from the original list.
Each list is for client communication, and the duplicates require different communication than the remaining names.
Very helpful 👌