ARRAYUNIQUE(if value appears more than twice)

Topic Labels: Formulas
1602 6
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer


I am trying to do a rollup that will only show unique values that appear more than 2 times. In essence, ARRAYUNIQUE(if value appears more than twice).

Anybody have any suggestions?

6 Replies 6

Hi @Michaela_Kendall,

I’m not sure there will be a way to do this with a Rollup field, since there is no concept in the formula functions of an iterator to go through each item in the array of “values” and check how many times a particular “value” in the array occurs.

Can you explain what it is you are trying to accomplish more generally? Perhaps there is another way to achieve your ultimate goals here.

Sure! I am hoping to pull info from one table into another (by means of lookup or rollup or some other means), but I only want the unique values that appear more than twice.

Courses Table
Course Name | Center (or classroom) | Disciplines

Centers Table
Center | Courses (as linked from Courses Table) | Disciplines (should pull from the Courses Table - but only those unique values that appear more than twice)

So if a value only appears once in the list of disciplines, then you don’t want it to show at all?

Welcome to the Airtable community!

Do you want something like the last column in this screen capture?

This setup uses a junction table and a system of lookups, formulas, and conditional rollups.
I don’t have time to do a write-up now, but let me know if this is what you want, and I will see if I can find time to do a writeup. (Or if you want a personal walkthrough, you can book an an appointment with me from the link in my profile.)

Yes, that’s correct. I only want it to show if there are 3 or more occurrences.

Kuovonne, I think? It looks like it, but I am not 100% sure from the table that you show.