UNIQUE() Function for Excel 365 - Remove Duplicates Using Formulas
Excel 365 Formulas Course: www.teachexcel.com/excel-365-...
The new UNIQUE() function for Excel 365 allows you to quickly, easily, and simply remove duplicate values from a list using a single, simple formula.
Excel File: www.teachexcel.com/excel-tuto...
Excel Forum: www.teachexcel.com/talk/micro...
The UNIQUE Function is new for Excel 365, and you must have this version of Excel in order to use it.
This function allows you to generate a list of unique values, removing duplicates, while keeping the original data set safe and unchanged. This happens because we use a formula to put the new unique list of values into another place on the worksheet.
This function uses the new calc engine and Spill features for Excel 365 and it is pretty cool.
With the UNIQUE() function, you can:
- Generate unique values based on a single column.
- Generate unique values on multiple columns.
- Return entire unique data sets.
- Return single or multiple specified columns of unique data.
This tutorial shows you many ways to use this new and amazing function.
I hope you enjoy the tutorial! :)
TeachExcel.com
#excel #tutorial #howto
Пікірлер: 13
Thanks for the great examples using UNIQUE and the benefit of using tables. Very helpful. Thumbs up!
@TeachExcel
3 жыл бұрын
You're very welcome Wayne! Thanks)
Excellent video, thank you so much appreciated
Thank you for this excellent explanation!!!
@TeachExcel
3 жыл бұрын
You're very welcome and I'm glad you liked the explanation :)
Thanks 👍
Great Tutorial!I Use UNIQUE() And SORT() Usally Together On Workbooks I'm Sent To Update And Tidy Up..Thank You Sir :)
@TeachExcel
3 жыл бұрын
Thanks! :) And that's a great function combo, really saves so much time!
Please provide video for For entire sheet (large data set)
👍🏻
almost same with Sql
Sir I have only one question. Is VBA still have strong future? I want to start learning VBA. Kindly reply?
@TeachExcel
3 жыл бұрын
If you work in an office then yes. If you want to learn a programming language to become a programmer and do anything outside of an office setting, then you should probably focus on another language.