00:00Can I ask you a question? How do you find duplicates in four different columns like this
00:05on here? Well, that was one of the questions that one of my subscribers had inquired. And this is
00:10how I do it. The first thing you have to do is to make these four columns into a single
00:14column
00:14using a function called to call. And the argument in there will be the array of your data set like
00:21this. Close parentheses and hit enter. And basically you'll combine the four lists into
00:25one column. And after that, you can use the following formula to determine the duplicate values.
00:30The countif function counts the number of times the fruit name is repeated on your data set. And if
00:36it's repeated more than once, it is considered as a duplicate value. And the filter function displays
00:41a list of unique fruits identified as duplicate by the countif function. And after that, hit enter
00:46to accept the formula and this I a duplicate value on your complete data set. And as part of a
00:52cleanup,
00:52you can change the text color on this column to white like this. And then you're done.
Comments