The following is a visualization of the demanded in a simplified example:
What I need:
I need a formula that can give me the results in range A15:D16, on behalf of the following information:
Information:
There must be, and can only be, one of each type.
The priority of the formula must be:
- Constraint 1
- Constraint 2
However the secondary constraint must be fulfilled.
Aucun commentaire:
Enregistrer un commentaire