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

Pull Unique Number Value from a column

Topic Labels: Formulas
464 1
Showing results for 
Search instead for 
Did you mean: 

I use the ARRAYUNIQUE formula often. It works great with text, but not well with numbers. I am failing to pull a unique value that is found within a cell/column.

For example, if a cell contains “Tuesday, Tuesday, Tuesday,” I can use the ARRAYUNIQUE formula in a new column to show only “Tuesday”

However, I cannot get the same to work in a number format. Any suggestions?

I am using a lookup based on a field and it is pulling multiple numbers that are not unique.

1 Reply 1

Ignore me - I am an idiot :slightly_smiling_face: