How do you find duplicates in a list?
This question has been posted here before, and tons of suggestions have been made, but no real solution has yet to be implemented that's practical and functional.
"Why is this so hard?" you ask???
Because many years ago, a decision was made about the following:
But why would they do this? Why would they automatically put in a formula, around the formula I'm making?
That's a good question, and one I asked many years ago when this first came up; the answer I got was something akin to, "we're trying to help and make it easy for non-technical types."
------------------------------------
So I pose the question again... How do you find duplicates in a list?
Any method that you may try (other than some completely impractical unwieldy formulas) will reduce your resultant list to it's simplest terms - the very thing you're not trying to do.
--------------------------------------------------------------------
Proposed Solution
-----------------------------------------------------
But.... if you remove this automatic reduction to simplest terms, then the following would work:
LIST(1, 2, 3, 3,4) - LIST(1, 2, 3, 4) = LIST(3)
Thus allowing me to find the duplicate.
-------------------------------------------------------------------------------------------------------------------
Please and thank you... this has been a long time coming, and certain advanced calculations and functionalities won't work unless we can find duplicates.
@Arthur_Rallu This is one of the few - in fact now that I think about it... this might be the last - data manipulation functionality that AppSheet can't do.
This is an essential feature that we greatly need in our international studies. Essentially, we need an expression that can subtract one list from another and show the actual result - NOT removing duplicates. Such an expression would be immensely useful.
Upvote!
Is there a work around? I'm stuck trying to figure out a solution
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |