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.