How can I use an array formula to return column headers where the cell value is 0 but NOT blank-CodePudding

Home > Blockchain > How can I use an array formula to return column headers where the cell value is 0 but NOT blank

How can I use an array formula to return column headers where the cell value is 0 but NOT blank

Time：01-10

In a Google sheet, I have an array of student results, with the score in marks for different objectives in some recent projects. Here's an example: