Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Return one item from lookup list if the next item in the list is the same as the first

Topic Labels: Formulas
Jump to Solution
1421 3
Showing results for 
Search instead for 
Did you mean: 

My base is for keeping track of genealogy research projects.

The Main Table is a list of projects that links to a People Table and a Timeline Table

People Table:
Has columns for First, Last and Middle name.
Has a column that concatenates to list the Full Name and the Primary record field


Timeline Table
Each record is linked to a project from the Main table and a person. The same person can be linked to multiple timeline records
Has a lookup column to display the Full Name field from the People Table


Main Table
Lookup pulls the Full Name from the Timeline Table and repeats it since a person can be linked to multiple records in the Time Line


I want to create a new column in the Main Table that lists the Full Name only once. Something like this: List the first name in the list, if the second one is identical, then don’t list it, etc. through the list of names in the lookup column.

I’ve really had good luck finding formulas for what I want to do by searching the forum, but not having luck on this one. Any help will be appreciated.

Thank you,

1 Solution

Accepted Solutions

Hi @Stacey_Cummings,

Try a Rollup field instead of Lookup field and use the ArrayUnique


See Solution in Thread

3 Replies 3

Hi @Stacey_Cummings,

Try a Rollup field instead of Lookup field and use the ArrayUnique


That worked perfect! I’m learning a lot from everyone who has a lot more experience than I do with formulas. I haven’t even begun looking at rollups, or understanding when to use which one, more to learn!

Thank you again,

Im glad it worked Stacey :slightly_smiling_face: