Excel / Macro LOGIC puzzle solver

  • Posted
  • Proposals 4
  • Remote
  • #160537
  • Awarded
Dave G.
Evan D.Danielle A.Alfred B. have already sent a proposal.
  • 0


Experience Level: Intermediate
Excel logic puzzle!
OK, see attached sheet. We need a formula / Macro that will create the shortest unique combination for each identical model code from the 4 product descriptions.

Solutions are shown in the example attached.

Enjoy the puzzle!

Clarification Board

  • Diana D.

    I don't understand everything.
    ¿do you need a formula that generate a unique key?
    would I receive an excel with information from column c and you need a formula to fill column B? Which is the criteria to fill column B?