Pull Unique Number Value from a column

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.

Ignore me - I am an idiot :slight_smile:

1 Like