Excel UNIQUE Function | Excel One Minute Functions Explained

Excel's UNIQUE function returns a list of unique values in a list or range. If you have a column in Excel for "Country" and listed are USA, USA, France, France, Belgium, Spain, Belgium, and France, the UNIQUE function will return USA, France, Belgium, and Spain. The UNIQUE function can return distinct values or unique values.

Syntax of Unique
=UNIQUE(array,[by_col],[exactly_once])

Who has the UNIQUE function? Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 202, Excel 2021, for Mac, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones.

Other Youtube videos on Unique function by Chris Menard

#excel #excelfunctions #chrismenard #chrismenardtraining #microsoft #microsoftexcel

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[LuzAvendano-tjgk]

Thank you Chris. You are the best of the best. I hope you get subscribers by the millions!

[stephenwalsh]

Thank you for being brief and to the point!!!!

[paulgwyne]

Fits my attention span exactly! Great video! You've just earned a subscriber!

[prontera]

Thank you my good sir. you save the day.

[tacijjola]

Thank you Chris. My functions savior! :)

[gregorytaylor]

Very helpful tutorial to understand what these formulas return. Thanks!

[nanettereyes]

Thank you. You answered my question. 👌

[DROIDFARM]

Thank you for the nice short explanation! Liked and subscribed!

[Ugly_Tsarevich]

I’ll be trying these at work. I work at fraud and a lot of charges/adjustments are shown on excel. I used to use the conditional option to see the shipments without any credits but I don’t know if it’s because there are a lot of filters too, but more often than not I don’t get what I wanted. Hopefully this is a better option.

[ryanobray]

It'd be nice if UNIQUE, SORT and FILTER would work on Excel for Mac. Get with it Microsoft.

[RAADRAEIR]

Thanks for the tutorial Chris, very helpful. Question if I may, how would I use this function to get the number of unique values, instead of a list of text/names itself? I mean, total number of unique values in column G, if G was zipcodes instead?

[annamoodler]

Great tutorial, thank you! Is there a way to find distinct values from many columns (e.g. containing names)?

[moesadr]

Can someone please explan how we also can the get the number of repeats for each unique value? Similar to Countif to ge the total number of each value within a coulumn?

[eleonoraz]

Thank you! How do you turn these unique records into column headings?

[slocum]

Hi Chris,

How about unique values from 4 diferrent columns that are different? Like member ids, event, load date and event date?

[sureshrouniyar]

How can we use this unique function to get unique items from multiple worksheets

[carlrigefsky]

Is it possible to make unique case sensitive so ABC is different from abc?

[mahdiafrah]

my computer is Mac and Unique Fuction has not work ? any help plz.

[darrentong]

Does this formula available in excel 2016?