![]() There are solutions below, but before you look at them, try to find your own solution.ĭownload the sample file (#4) from the Excel Count Functions page on my Contextures site. How would you calculate the number of matches? Get the Sample Data For example - 1,2,3,4,5,6 is be a duplicate of 3,4,5,1,2,3 - all 6 numbers are the same. It doesn’t matter if the numbers are in a different order. In each row, the goal is to find out how many times that set of 6 numbers appeared in the table. ![]() The 7th column, Dups, is where I tested my formulas. There are 11 rows of numbers, and 6 columns. ![]() To find a solution, I set up a small table with random numbers. Did any of the number sets appear in the list more than once? How would you solve this problem, and count duplicate number sets? There were hundreds of rows, with 6 numbers in each row. Recently, someone asked me how to count duplicate number sets.
0 Comments
Leave a Reply. |