Excel Formula Challenge #7
Here is an interesting yet brain-bending formula challenge, Table in the screenshot shows five records, Write a formula to count the dups and unique records. notice that values in same records are not in same order every time. they are shuffled .
- You have to solve it by excel native formulas only
- No helping columns.
Download Sample fileFormulaChalllenge #7 (56 downloads)