Request for basic functions: Mode.Mult() and ContainsAll()

When comparing and analyzing lists, sometimes, the current Mode() and Contains() functions do not suffice. Therefore, please consider adding the following:

1. Mode.Mult(): a list may have more than one value that occurs most frequently. The current Mode() function only returns the first mode though. What if you want to know ALL of them?
2. ContainsAll(): the current Contains() function returns true when ANY of the items in the first list are found in the second list. There are times when you want to know if ALL items in list 1 are present in list 2, however.

Here’s a potential use case for these functions.

Kind regards,

1 Like

Hey Kevin, thanks for the feedback.
Just wanted to share that we just released ContainsAll().
More details here: Three New Formulas - ToTime(), ContainsAll() & ContainsOnly()

Thanks, Angad. I saw it in my email, great work!

1 Like

In the meantime, here’s a solution to the multi-mode problem that might work for you. Hope it helps! :slight_smile:

1 Like