•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
UNIQUE not applying to array output
Our take
If you're encountering issues with the UNIQUE function not applying to your array output in Excel, you're not alone. In your case, trying to extract distinct values from a list like "Apple, Apple, Apple, Mango" using UNIQUE(TEXTSPLIT) can be tricky. It’s essential to ensure that the data is formatted correctly and that you're using the right syntax. This will enable you to achieve the desired output of "Apple, Mango." Let’s explore some solutions to streamline your data management effectively.
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?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
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