Excel Formula Challenge #7

Challenge

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




Try yourself first, but here are the solutions.
Solution (34 downloads)
Explanation (19 downloads)