Welcome to this Tamil tutorial video. This video teaches you how to use the unique function in Excel to extract a list of distinct items from a range or array. The unique function is a dynamic array function that returns an array of unique values in a list or range. You will learn how to use the unique function with different arguments, such as by_col and exactly_once, to compare and extract unique values by rows or columns, and to filter out values that occur more than once. You will also see some examples of how the unique function can be combined with other functions, such as sort and filter, to create more complex formulas. By the end of this video, you will be able to use the unique function to perform various tasks, such as removing duplicates, finding unique names, or creating a drop-down list of unique values.
This is a part of our Series - Excel for Beginners in Tamil
If you find this useful, please subscribe and share it with your friends and family and do like our videos..
#Exceltamil, #naalumpagirvom, #excellearningintamil, #Exceltheme, #exceltutorial , #MSExcel, #MicrosoftExcel, #exceltips, #excelintamil, #TOCOL, #TOROW, #unique ,#exceltamil
Негізгі бет Excel - How to use Unique function to list Non-duplicate items | MS Excel in Tamil | Naalum Pagirvom
Пікірлер