![]() Hence, you can see that we only have unique values in the dataset.Here, we will unmark Duplicates since we want to remove them.Furthermore, we will click on the drop-down icon of the Values columns.Therefore, you can see the column headings have a Filter icon.Then from the Sort & Filter group, select Filter.Next, we will remove the Duplicates using the Filter tool.Furthermore, we will drag down the formula with the Fill Handle tool.Therefore, you can see the result in cell D5.Explanation: D5 returns Duplicate since the formula detects a duplicate value.If the value is false, the formula will return “ Duplicate’’. IF(ISERROR(VLOOKUP(C5,$B$5:$B$14,1,FALSE)),”Unique”,”Duplicate”) → If the value is true, the formula will return “ Unique”.Col_index_num is 1 and is (FALSE) as we want the exact match. Here, Lookup_value is C5, Table_array is $B$5:$B$14. VLOOKUP(C5,$B$5:$B$14,1,FALSE) → this formula will find out the exact match of cell C5 value in the range of cells $B$5:$B$14. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |