Excel Uniqueness: Extract Unique Values in Excel - Episode 2236

Thanks for this beautiful video.
I need your help, please.
This new spilling automation is annoying, specially when we have situations to not spill cells.
Can you please tell me how to turn off/stop that spilling?

Om pure and simple

The way unique is used “Microsoft” unique is exactly what I need. I’ve had a hard time finding a way to get unique only.

This is useful for comparing two lists, in my case computers connected to computers in the field. This allows me to create an email list of computers not connected.

Unfortunately, the unique and sort functions are not available for the home version............but for business standard version, it is too expensive ......is there any other way to get the unique value in another way?

Excellent video. I have a list of names which i need to extract only names who worked on Friday and Saturday only. Can you please advise me how to do this? thanks a lot

I'm coming back to this video, because there is so much value, especially in the second half when you show, how to nest the FILTER function inside the UNIQUE. Nice.

Great video! Have you tried using the UNIQUE formula when your list has blanks? Have you figured out how to exclude those?

I don't have this function in my Excel! It's kind of beta or something...

The problem with this UNIQUE function is that you can't use it inside an Excel table - and I need it there, because where I work, we format all ranges as a tables.

Amazing Video Bill. Thank You.

i need this thing in my pc, and when i went to confirm in my pc there was nothing like this shit. was this a joke bro ???
what is this ???

Why would you post a video tutorial for something that is in the testing phase (Insiders only) and not the general public? A year later and it's still not part of Excel yet. Was excited to see the video, until I found out the function wasn't there. :-/

Forgot about this function. Still haven't seen it, I have Excel 2019 at home and I know that version doesn't have this function but at work we have the 365 Professional and this function isn't there either. Just will keep using VBA code to quickly make a advanced filter range to get a unique list.

UNIQUE function NOT in Excel 2019 THAT SUCKS!!!

Hi there and thanks for the videos!

Is it possible to use the new dynamic arrays to create a unique stacked list from multiple columns within the same table? I have a table with 6 columns side by side that I put in names of clients that I am bidding to. Sometimes it is 1 client so only 1 col 1 has a value. Next col might have 3 clients so 3 cols have a value. These values can repeat in different rows in any of the 6 columns. I am trying to find a way to use dynamic arrays to get a list of unique values that occur in all 6 columns. Anyone have success in a similar situation of have an idea of how I can pull this off?

It does not work in excel 2010

Can it be used in Data Validation?

Dell Mr. Jellen

Which excel version that contain these new formulas? I use Office 365 Pro plus subscription , but I'm not found these formulas that you have mention them.

Hello. Two questions: (1) What is the release date of these functions? I have an Insider Account, but my Excel 365 doesn't have them (just downloaded last update); (2) Do these functions work inside an Excel Table (Ctrl + T)?

Wow, these new functions are amazing.
Thanks for sharing and explaining in details.

This is life changing!

Imbelievebale :-) Thanks to Excel and Mr Excel Thumbs Up

Unique is the best function!

I can't wait till my company gets these updates. These new functions will save lots of time; the older ways to do this are kind of a PITA.

These functions are a sea change. Wow.

As soon as you showed spill, this was the first thing that came to mind. "Can you get a unique list?". I even typed that comment. Then saw this video and went back to removed my comment. I will use this for sure.

What a breakthrough..!!

Thanks Bill, I have created a macro to return a unique list from one column, but with this new function no way!!!

If I copy the cell that has the Unique() formula in it and paste special values that somewhere else, does it paste all of the results as you would expect?

All those crazy Array Formulas of the past are not needed now : )

UNIQUEly awesome!!!!

Amazing!! I will definitely buy your new book !!

With UNIQUE(), it’s going to be much much easier to pull out non-duplicates in a list !

Whah oooooo !!!

Super cool! :)

Wow. Amazing. So much work to be saved.