Help

Pull Unique Number Value from a column

Topic Labels: Formulas
726 1
cancel
Showing results for 
Search instead for 
Did you mean: 
David_Walters
6 - Interface Innovator
6 - Interface Innovator

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
David_Walters
6 - Interface Innovator
6 - Interface Innovator

Ignore me - I am an idiot :slightly_smiling_face: