Teachtoeach presents How to Extract Unique Value List by Using Formula in Excel in Hindi . In this video I am trying to teach you Formula to get unique Value in excel.
I know we have different option to get the unique names from the list. Like A) Remove duplicates option 2) Using Conditional formatting and so on but this formula is the best option.
Here we will using three 4 formula to get the desired output.
1) Index Formula : To fetch the value ., If both row_num and column_num parameters are used, the INDEX function returns the value in the cell at the intersection of the specified row and column.
2) Match Formula : The MATCH function searches for a specified item in a range of cells, and then returns the relative position of that item in the range.
3) CountIF Formula : The Excel COUNTIF Function - Returns the Number of Cells in a Range That Satisfy a Given Criteria
4) IF Error Formula : use function to trap and handle errors in a formula. Value is the argument that is checked for an error.
We are using above formulas then click CTRL + SHIFT + ENTER simultaneously because it is an array formula then we get the exact answer.
It is a very difficult task to anyone. If you are really interested to learn this trick then this video never lets you down. On KZitem, only just few videos are available on this How to get unique values from duplicate list in excel.
Thanks for watching.
It is humble request to you. Please subscribe my KZitem channel by click on this link.
/ teachtoeach
Website : www.Teachtoeach.in
#extractuniquevaluesbyformulainexcel #Excel #teachtoeach
Some Popular Videos are :-
1) How to Count Words in a Cell in Excel in Hindi - • How to Count Words in ...
2) How to use Vlookup Hlookup Formula Together in Excel in Hindi - • How to use Vlookup Hlo...
3) How to use ISBlank Formula in Excel in Hindi - • How to use ISBlank For...
5) How to use Indirect Custom Validation in Excel in Hindi - • How to use Indirect Cu...
6) How to Enter Large Digit in Excel in Hindi - • How to Enter Large Dig...
7) Magic Trick - How to Find any Position of Space or Character in Excel - • Magic Trick - How to F...
7) Motivational Video for Students | अगर CBSE UP Borad Exam में फेल हो गए तो इस वीडियो को देखें - • Video
8) What is Objects Methods Properties in Excel VBA in Hindi | Part 4 - • What is Objects Method...
9) How to Create Class Intervals Auto Fill List in Excel in Hindi - • How to Create Class In...
10) Excel VBA Editor Tutorial in Hindi - • Excel VBA Editor Tutor...
11) Nested IF Formula in Excel in Hindi - • Nested IF Formula in E...
12) How to Record Macro in Excel in Hindi - • How to Record Macro in...
13) How to make Paytm QR code in Excel in Hindi - • How to make Paytm QR c...
14) Excel VBA in Hindi | Excel VBA Tutorial in Hindi - • Excel VBA in Hindi | E...
15) IF Formula in Excel Hindi IF Function in excel - • IF Formula in Excel Hi...
16) How to Find Duplicates Using Vlookup Formula in Excel Hindi - • How to Find Duplicates...
17) Reverse Name in Excel Hindi - • Reverse Name in Excel ...
18) How to split middle name in excel in hindi - • Split Middle Name in E...
19) Fill series option in excel - • Fill Series in Excel i...
20) How to split first name in excel - • Split First Name in Ex...
21) How to use Asterisk Wildcard Character in Excel in Hindi - • How to use Asterisk Wi...
Негізгі бет How to Extract Unique Values List by Using Formula in Excel in Hindi
Пікірлер: 113