List(1 , 2 , 3 , 3 , 4) - list(1 , 2 , 3 , 4) = list() <--blank?

[MultiTech]

I’m trying to find the duplicates of a list, this way I can base a special formatting rule off of it, but I’m running into the intelligence of the platform doing something I’m not wanting

Like the title says, I have the following expression results:

list(1 , 2 , 3 , 3 , 4) - list(1 , 2 , 3 , 4) = list()

• The first list has two 3s in there (that’s the duplicate I need to isolate out, and any others).
• The second list is generated FROM the first list via UNIQUE()
  So I guess you could test: list(1 , 2 , 3 , 3 , 4) - UNIQUE(list(1 , 2 , 3 , 3 , 4))

I’m looking for the result: list(3) - because if I take things one-for-one that’s what I would get.

But AppSheet is an intelligent platform, and before a few months ago we didn’t have the UNIQUE() function, so (after tons and tons of bugging) the devs put in some auto-magic to make lists unique when you do any list-math on them.

But we have UNIQUE() now, so this behavior is actually a hindrance.

---

I was hoping that LIST() might tell the system, “Hey, take this list literally; subtract one from the other and don’t do any magic.”

But no. @Adam any suggestions? Thanks

Edit: Feature Request: DUPLICATES()??? NONUNIQUE()… THEREPEATINGONES(), DOPPELGANGERS(), CLONES()