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 .

Conditions –

  • You have to solve it by excel native formulas only
  • No helping columns.

Download Sample file

FormulaChalllenge #7 (69 downloads)

Try yourself first, but here are the solutions.
Solution (38 downloads)
Explanation (25 downloads)