UNIQUE function in Excel (with 6 examples) | Remove duplicates with a function | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★

★ Download the example file:★

★ About this video ★
I can’t even begin to count the number of times I have created a unique list in Excel, all of which used various manual methods. When Microsoft announced dynamic arrays in September 2018, they also announced a host of new functions, one of which is UNIQUE.

UNIQUE is a new function which returns the distinct or unique values from a range or array. This is triggered by the normal calculation process, so is completely automated.

Through 6 examples, you will learn how to master this new function.

★ Download 30 most useful Excel VBA Macros ebook for FREE ★

★ Where to find Excel Off The Grid ★

#MsExcel #ExcelOffTheGrid

[er]

Clearest explanations I’ve found. Great work

[Sri-Nivas]

You are the true master in excel DA.. Want more excel topics from you..

[spiritualbeingshavinghuman]

this is by far, one of the most helpful videos i've seen. thank u so much.

[juansebastianbuitrago]

Perfect. No more words. Thank you for you explanation.

[henrytran]

Precise and articulate. Thank you very much for sharing your talents.

[playincognito]

Great tutorial. Opens up so many new possibilities in Excel !! Had no idea you could use the # so I worked around it by copying the results from my UNIQUE formula to another area of the worksheet.... Thanks so much !! :-)

[roberth.]

Well presented. Thank you for the practice worksheets.

[Chef-]

What a great find on utube...downloaded really really helpful examples . Well presented videos and easy to follow steps into formula I had not used before....Appreciate you sharing.

[akaninyenemaurice]

I just came across tutorial by "excel off the grid" for the first time today. I must confess that i've not really enjoyed online tutorial videos like I enjoyed this. I tried out all the 6 examples using the excel file provided in the description. I am so grateful for what you do that I have decided to subscribe and follow you on twitter. well done.

[AmitKasarLive]

Very informative video, Learn lots of new stuff from this.

[nancydizon]

Oh thank you so much! I was trying to search how to do such thing in excel and I found your channel. It's amazing to use "UNIQUE" function in excel. It makes work load easier. It is really unique as the name implies. You are a superb teacher! Thank you! Looking forward to your other teaching videos. God Bless!

[rameshhariharan]

Im from india great teacher. Great. Thank u so much .

[daleanderson]

Very good. Thank you. I'm looking forward to the rest of the videos in this tutorial. I'm now going to practice with the example files. Its great that you included them. The videos are great for the basics and the example files allow us to learn by doing.

[SamiElzaim]

Very instructive videos! Thanks and keep on sharing please.

[taymaateyah]

Thank you so much sir, great and simple explaination 🌸🌸

[josuezuniga]

You're awesome! Thanks for the video

[EvanSarris]

One of, if not the best example of teaching I have ever seen. Can’t thank you enough. I was blown away by the capabilities and versatility of the Unique function.

[sumardjo]

thanks
this very complete to learn
because sample file and user guide already
nice and excellent
bravo
thank you very much

[nicoleownby]

Great tutorial! I'm stumped by one thing with an sheet I'm working on and would love help! What if you wanted to a count of something within that unique list? Using the example at 8:20- what if I wanted a count, in row table format, showing how many unique values last names start with (A-E, O-R) and (F-K) and (L-N) and (S-Z)? In this case there would be 3 Ws, etc. I have a list of names and a different person on my team is responsible for last names falling within their alphabet breakdown (shown in the parenthesis earlier).

[mdmueenpasha]

This is epic.. the examples were mind blowing ❤️