'how to sort a matrix generated by formulas against a column (excel)
Please have a look at this spreadsheets
I tried to make the questions that exist in the question sheets in different sheets but I have a problem sorting the matrix because it is generated by formulas in sheets Q1 AND Q2 AND Q3 AND Q4.
I built a column with the formula =COUNTIF.ENS(BDD!F2:F3907;'Q1'!A2:A19;BDD!J2:J3907;"YES") but I can't sort it with a another column create with the formula =UNIQUE(BDD!F2:F3907)
(I apologize but the Excel is in French)
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|