This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I'm trying to use the @Unique function in my Office 365 ProPlus Subscription Excel that I'm using at work. I'm still on Windows 7 there unfortunately.
The @Unique function is available, but it only returns the first value in a selected range of values for me. It does not populate down the column with the remaining unique values in my array.
In the examples it looks very easy to use but I don't understand what I could be doing wrong. Has anyone else got this happening for them? Is there something incredibly obvious that I'm missing.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
The @ operator causes that. It prevents an array formula from spilling into the cells below.
=UNIQUE(A1:A16) will return all unique values, spilling to as many cells as needed.
=@UNIQUE(A1:A16) will return only the first of those values.
So remove the @ from your formula.
Thanks so much! I'd guessed it was something ridiculous. I suppose I'm just so used to putting @ into my formulas I didn't notice there was no @.