1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

UNIQUE not applying to array output

I have an entry that goes Apple, Apple, Apple, Mango
I want the output to be Apple, Mango

But when using UNIQUE(TEXTSPLIT( , it doesn't work. I have tried asking AI about UNIQUE behavior on array results, and it should works just fine but my excel file does not seems to work. Any clue?

submitted by /u/Ninjapotato17
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#UNIQUE
#TEXTSPLIT
#Excel
#array
#output
#behavior
#results
#entry
#apply
#works
#Mango
#AI
#file
#clue
#submitted
#comments