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 (63 downloads)

Try yourself first, but here are the solutions.
Solution (37 downloads)
Explanation (24 downloads)